ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems loading user form (https://www.excelbanter.com/excel-programming/391935-problems-loading-user-form.html)

Stu W

Problems loading user form
 
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

Stu W

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



All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com