Exit Userform and run code

[davidam]

Hello All,
I tried wanted to have some code that executed when I clicked the Red X on a user form...I used CanceQuery for this. I have other buttons on the form and each of those buttons has the line "Unload Userform ". I am pretty sure that what is happening ,however, is that the CancelQuery code is running when the Unload Userform command is encountered. Is there a way to install some code that will ONLY run if/when I use the red X?
Thank you

 

[Glory]

Set a toggle in the cancel button that is recognized by the terminate event.

That way when the cancel button triggers, it will not trigger the code. Only unloading the userform with the red X or using some other method will trigger it.

 

[davidam]

Yes that is probably the way to go...I have found toggles to be troublesome in the past because you always have to make sure they get re-set...this is a good situation though, because I can wrap the button unload commands with a toggle trip and re-set and make the query/close conditional...Thanks!