How can I avoid form destruction??

D

Dag Johansen

Hi,

I have a form which requires a lot of initialization, and
I would like to ensure that I only need to do this once;
so the application is responsive once it is done
initializing.

The form is a modal dialog box which closes when it is
OKed or Cancelled. Trouble is, if the user doesn't choose
OK or Cancel, but instead closes the form, then Excel
disposes the object and all state is lost.

How can I stop Excel from destroying the form? Can I
cancel the UserForm_Terminate event? (If so, how is it
done? I'm not fluent in VB...)

Any help would be greatly appreciated. Happy coding!

Dag
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
How do I clear a form? 0
Calling Button click event from Form initialise event? 2
Form Unload? 2
How to prevent form from closing 5
How to create skip pattern in access 2013 form 0
Prevent UserForm by Ctl + Break (Unload Form) 2
How can I force a workbook to close? 6

Top