View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Userform activate event question

try unloading the form rather than hiding it.

Is your code in the Activate Event or the Initialize event. The latter only
fires on creation of the form, not unhiding it.

--
Regards,
Tom Ogilvy

dan wrote in message
...
I have a form with several listboxes buttons etc that is called up via a

toolbar button which then calls a macro that does a frmMyform.show.

I have several initializing tasks which must be done that I have put in

the form activation event. on OK or quit out of my form I do a
frmMyform.hide.

All works well the first time around.

The next time however the activation events do not get fired (when I again

do a frmMyform.show).

Am I opening and closing using the common practice? If I move my

initializing events to the macro that calls the form in the first place it
fails because the form object has not been created.

Thanks in advance ...