It is likely that there is something in the userform's _Initialize event that
is causing the problem- the debugger will confusingly point to the
Userform.Show line in this case. Click the Step Into debug button and keep
stepping through until you find the line that is causing the issue.

Cheers,
Dave

"Chris" wrote:

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?