In the VBA Editor, go to the Tools menu, choose Options, then the General
tab. There, select the "Break In Class Module" option in the "Error
Trapping" frame. Now run your code. It will break on the actual line of code
that is causing the problem.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)
"Chris" wrote in message
...
For some reason my program isn't working. In the excel sheet, I have a
user
click on a button to open a userform.
Now when that button is clicked, a user gets
Runtime error '13'
Type Mismatch
I click on Debug and it goes to
Sub Show()
UserForm1.Show
End Sub
I have no idea why its doing this all of a sudden. Does anyone else?