![]() |
type mismatch when opening a userform
This is giving me a type mismatch error.... it is a button on the worksheet, used to open a userform. It works every other time I have tried it... but not this time. Private Sub CommandButton1_Click() MyUserForm.Show End Sub Any ideas? Thank you! |
type mismatch when opening a userform
Many times you will get the debug hilite on the show command when the
problem is really in the initialize event code. Put a breakpoint at the beginning of the initalize code and run the show command. Then when it breaks, use F8 to step through and find the actual problem line. "SMS" wrote in message ... This is giving me a type mismatch error.... it is a button on the worksheet, used to open a userform. It works every other time I have tried it... but not this time. Private Sub CommandButton1_Click() MyUserForm.Show End Sub Any ideas? Thank you! |
type mismatch when opening a userform
Brilliant! Thank you! On Oct 2, 2:55*pm, "JLGWhiz" wrote: Many times you will get the debug hilite on the show command when the problem is really in the initialize event code. *Put a breakpoint at the beginning of the initalize code and run the show command. *Then when it breaks, use F8 to step through and find the actual problem line. "SMS" wrote in message ... This is giving me a type mismatch error.... it is a button on the worksheet, used to open a userform. It works every other time I have tried it... but not this time. Private Sub CommandButton1_Click() * *MyUserForm.Show End Sub Any ideas? Thank you!- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 09:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com