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



 
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 09:35 AM.

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

About Us

"It's about Microsoft Excel"