A
Alan
I have a simple VBA subroutine that simply starts up a user form
("SelectPrinterForm"), as follows:
Sub SelectPrinter()
SelectPrinterForm.Show
End Sub
SelectPrinter() is assigned to a button on a worksheet. All this was
working fine. Then, all of a sudden (close workbook/Excel and
reopen), it stopped working. I get a run-time error 438 ("Object
doesn't support this property or method") when I try to show the form
with this code, which is highlighted:
SelectPrinterForm.Show
Any ideas on why this might be? Thanks, Alan
("SelectPrinterForm"), as follows:
Sub SelectPrinter()
SelectPrinterForm.Show
End Sub
SelectPrinter() is assigned to a button on a worksheet. All this was
working fine. Then, all of a sudden (close workbook/Excel and
reopen), it stopped working. I get a run-time error 438 ("Object
doesn't support this property or method") when I try to show the form
with this code, which is highlighted:
SelectPrinterForm.Show
Any ideas on why this might be? Thanks, Alan