ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run-time error 438 (https://www.excelbanter.com/excel-programming/425502-run-time-error-438-a.html)

Alan[_8_]

Run-time error 438
 
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

Alan[_8_]

Run-time error 438
 
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.



All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com