Difference between Query_Close and Terminate Events

[kpark91]

Hello,

I've been working with userforms for quite some time now
and I was wondering what the difference between Query_Close and Terminate events of the userforms.

I know Query_Close has Cancel and CloseMode variables while Terminate doesn't but are there any other differences?

Thank you in advance,
kpark.

 

[RoryA]

QueryClose happens first to allow you to decide whether to unload or not.

 

[kpark91]

I'm not sure what you mean by that.

Could you expand on it?

Thanks so much for the response

 

[RoryA]

When you try to close the form, the QueryClose event occurs first. It gives you the Cancel and CloseMode arguments so that you can determine whether to unload the form or not. If you allow it to proceed then the terminate event happens when the form is unloaded - you can't cancel that.

 

[kpark91]

Ohh I understand now.

Thank you!