View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default UserForm Wont Load

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