View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stu W Stu W is offline
external usenet poster
 
Posts: 24
Default Problems loading user form

Problem solved. Even though the ufMain.Show line was identified as the
offending problem, the form was trying to load a value that wasn't there. So
the offending line was really elsewhere in the code.

"Stu W" wrote:

I'm trying to load a user form:

Sub ShowUFMain()
ufMain.Show
End Sub

I get a Microsoft Visual Basic dialog box:
Run-time error '-2147352571 (80020005)':
Type mismatch

This was working earlier. What to do???

Excel 2003 VBA