How to run sub if userform closes on error

[dchaney]

Hello all,

I have a userform currently that opens when the file opens, it is a "floating" form so it is always up, I hide all borders and disabled the X close button on the excel file. Everything is working great, except if for any reason there is an error that causes the userform to close there is no way (shot of right clicking and exiting program) for the user to close the file.

for instance, if I step through any portion of my code and I hit stop, the userform closes... does this close fire any additional subs?

Is there anyway at all to have a sub fire if the form closes for any reason at all? The Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) does not work, already tried that...

 

[Norie]

Have you looked at the userform's Terminate event?

 

[dchaney]

Yes, it does not seem to run ether, I am having a difficult time to get the form to "Error" as one of my co-workers and said it did on him this morning. I have the terminate sub set up to run incase. Thanks