Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |