View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fst1 Fst1 is offline
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.