LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why wont the Excel file load when I double click on it? Office Use Excel Discussion (Misc queries) 2 June 13th 08 08:26 PM
Workbook wont load from shortcut Carol Excel Discussion (Misc queries) 5 September 14th 07 04:04 PM
*.csv file wont load correctly Nightwing Excel Discussion (Misc queries) 3 December 1st 04 03:48 PM
Label Caption Just Wont Work on UserForm K[_3_] Excel Programming 2 September 15th 03 03:29 PM
Load a Userform Nick Excel Programming 1 September 10th 03 03:24 PM


All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"