Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel spreadsheet 2003 wont show content when moved to another par | Excel Discussion (Misc queries) | |||
How do i make the whole y axis label show up it wont show the end | Charts and Charting in Excel | |||
forms that suddenly wont appear using the show method in VBA a bug or a corrupted file perhaps ? | Excel Discussion (Misc queries) | |||
form wont show or load | Excel Programming | |||
Form wont hide | Excel Programming |