ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   type mismatch when opening a userform (https://www.excelbanter.com/excel-programming/434466-type-mismatch-when-opening-userform.html)

SMS

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!

JLGWhiz[_2_]

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!




SMS

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