Run-time error '13' Type mismatch on UserForm

[ElvisHess]

I have a spreadsheet that all of a sudden when I click a button to call up the UserForm. I get the subject error and the userform does not open. The Debugger stops at the line

UserForm.show

I can't even open the UserForm when I hit F5 in Visual Basic

Any Ideas.

 

[shg]

What's the name of the userform? It should be UserForm1 if it's the first form in a workbook and you haven't changed it.

 

[Norie]

Sounds like the problem could be in the userform's initialize event code.

Try one of these:

1 Goto Tools>Options... and select Break on All Errors on the General tab.

2 Start the form from design mode with F8 instead of using the sub that's showing it.

 

[ElvisHess]

I found an error in my initialization area. It had one of the #Value errors. I handled that with a if(iserror formula and it worked fine. Didn't know about the F8 method of tracking down bugs.

Thanks a million