Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default form wont show or load

Greetings all,
about a week ago, i posted asking how to open a user form
in excel. i got 2 replies. now i am trying to implement.

Sub ShowForm()
Load CalForm
CalForm.Show
AppActivate Application.Caption
End Sub

Can anyone see anything wrong with this code.
I put up a button that call this sub.
I get an error when i try to run it

run-time error 2147024809(80070057)
Could not find the specified object.

debug shows the code with Load CalForm high lighted
Try to run the code from VB Editor you get the same error
message as above but the VB Editor shows you the form in
design mode. click debug again and it return to the code
with load Calform highlighted.
I am at a loss on this one. anyone got any ideas.



Reply
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
How do i make the whole y axis label show up it wont show the end Jordan Charts and Charting in Excel 1 November 24th 07 06:07 AM
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
UserForm Wont Load Minitman[_4_] Excel Programming 6 April 29th 04 07:49 AM


All times are GMT +1. The time now is 05:49 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"