Overriding form close event

[Wes Grant]

Hello

I have a macro that gets user input, hides itself to generate a document,
and can be re-shown to make further changes. The problem is this: if the
user closes the macro with the close button on the top right of the user
form instead of using my 'finish and create' button that simply hides rather
than closing the macro, all of the variables are reset and further editing
is impossible.

Is it possible to overide the form close through the terminate event? If so
what should I return out of it? Thanks for the help in advance.

 

[Jezebel]

Read Help on the form QueryClose event.

 

[Wes Grant]

Thank You!!!!! The whole trick to VB is navigating its many dark sources of
documentation!