Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
runtime error 2147221005(800401f3)
Hi
I'm facing problem in ecexl once i open the work book , this below error runtime error 2147221005(800401f3) Invalid class string Private Sub Workbook_Open() Sheets("face").Select Range("A1").Select Application.ScreenUpdating = False Sheets("FOR").Select Range("A1").Select Load UserForm1 Application.ScreenUpdating = True UserForm1.Show End Sub |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
runtime error 2147221005(800401f3)
first, you don't need the Load UserForm1 statement - the form will be loaded
at the UserForm1.Show statement. I suspect the error is somewhere within the coding of the UserForm1 itself. Probably best way to find it is to put a STOP statement in the form's ..Initialize event and then use [F8] to step through things while it opens and see where it errors and determine what's causing the error, which helps determine how to fix it. "deen" wrote: Hi I'm facing problem in ecexl once i open the work book , this below error runtime error 2147221005(800401f3) Invalid class string Private Sub Workbook_Open() Sheets("face").Select Range("A1").Select Application.ScreenUpdating = False Sheets("FOR").Select Range("A1").Select Load UserForm1 Application.ScreenUpdating = True UserForm1.Show End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
Runtime Error 424 | Excel Discussion (Misc queries) | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |