View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Error Message "Runtime error '13' Type mismatch"

If could be that some code in the userform is causing the error. This could
be because the code was altered or data that the code was using has now
changed.

--
Regards,
Tom Ogilvy


"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?