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.