Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Minitman
It looks like you're saying the debugger highlights the Show line. If so, go to Tools - Options - General (in the VBE) and select "Break in Class Modules" in the Error Trapping section. Whenever an error ends on a class instancing line (like Show) it usually means the error is in the class module (the userform module, in this case) but that error trapping isn't set to go there. This will tell you which line is actually causing the error. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Minitman" wrote in message ... Greetings. I am running Office 2k on a W2k box with 1 gig of ram and an AMD 2400. I have a worksheet that has some UserForms on it. I have a later version of this same workbook that has the same UserForms on it. In the pursuit of streamlining the app, I eliminated all but one of the UserForms from the later workbook. Now it won't load! I went back to the older workbook and did the same and it works fine!!! I tried to delete and then replaced the Forms folder in the later workbook, but it still did the same, the older workbook still works fine. I keep getting this Microsoft Visual Basic message box: Run-time error '-2147352571 (80020005)': Type mismatch The debug then highlights this code: Private Sub StartInv_Click() Call PasteForm1 MakeNewInvForm1.Show <<< End Sub This is the same code and name that is used in the older version. Does anyone have any idea as to what to do next or where to look for information on this problem? Any help would be most appreciated!!! TIA -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why wont the Excel file load when I double click on it? | Excel Discussion (Misc queries) | |||
Workbook wont load from shortcut | Excel Discussion (Misc queries) | |||
*.csv file wont load correctly | Excel Discussion (Misc queries) | |||
Label Caption Just Wont Work on UserForm | Excel Programming | |||
Load a Userform | Excel Programming |