Run-time error 438

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
 
A

Alan

This is weird: I deleted the code hightlighted as an error and
simply tried to run the UserForm. The same error appears, but when I
hit "Debug," the error window just closes. I am not taken to an
offending line of code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to VB6 6
Went from Office 2003 to 2007. Error 438 VB v.6.5. 6
Run time error 438 1
RUN-TIME ERROR 438 2
Runtime error 438 4
Run Time Error 438 2
Run-time error 438 - using With 9
run-time error '438' 2

Top