Excel 2003 - Runtime 13 when loading userform from cmd button

[grip88]

I have been developing a form to enter data into a spreadsheet, it has been working fine, i havent changed any code recently but i have started to get a runtime 13 mismatch error.
This code is in a module that is called from the cmd button:

Sub Button1_Click()
Worksheets("Daily Records").Activate
frmDaily.Show
End Sub

The debug highlights the frmdaily.show line. I have looked on forums and tried the vbmodeless as well but it still doesnt work.

Any suggestions?

Thanks

 

[RoryA]

I suspect the error is actually in the startup code of the form. If you choose debug when the error occurs, and then press f8 repeatedly, you should get to the line that is actually causing the error.

 

[grip88]

Many thanks, I found the problem line of code!