View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default 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 ...