View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
 
Posts: 599
Default UserForm Wont Load

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