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: 3
Default form wont show?

greeting all,
I have a user form which i would like to pop up when
a button is clicked. I have the button on the sheet.
I am using the following code.

Private Sub CmdShowCal_Click()
CalForm.Show 0
AppActivate Application.Caption
End Sub

When i click the button, i get a runtime error...
Run-time error '-2147024809(80070057)
Could not find the specified object

odd thing is that it was working. I was modifing some
code in the form (not the CmdShowCal code) and when
i saved the file to retain changes, the runtime error
started poping up instead of the form.
The modification i did was to add 2 dim to 1 private sub
in preperation for adding more code.

Does anyone have some idea what is wrong?
thanks in advance to anyone who can help.


 
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
excel spreadsheet 2003 wont show content when moved to another par chris Hobbs - MCP, MCDST, A+ Excel Discussion (Misc queries) 1 November 20th 09 09:01 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
forms that suddenly wont appear using the show method in VBA a bug or a corrupted file perhaps ? Richard Finnigan Excel Discussion (Misc queries) 0 February 15th 06 07:12 PM
form wont show or load FSt1 Excel Programming 0 August 31st 04 06:33 PM
Form wont hide Tom Ogilvy Excel Programming 1 June 3rd 04 09:21 PM


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