Userform activate event question
 

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 ...

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 ...