Run VBA prior to form closing

[EssKayKay]

Is there a way to run a macro prior to closing a user form -- by clicking the standard "X" (close) button in the upper right corner not via a separate command button?

 

[dmt32]

Look at the usefrorms QueryClose event

Dave

 

[EssKayKay]

Thank you. . .

 

[dmt32]

Thank you. . .

Most welcome & appreciate your feedback

Dave

 

[EssKayKay]

SKK

 

[EssKayKay]

I may have found another routine that appears to be working - Private Sub UserForm_Terminate().
However, maybe there is some reason to shy away from this.

Any suggestions?

 

[dmt32]

I may have found another routine that appears to be working - Private Sub UserForm_Terminate().
However, maybe there is some reason to shy away from this.

Explanation for use of Terminate event in your project can be found in the VBA helpfile.
I suspect the QueryClose event likely to more appropriate for your requirement.

Dave

 

[EssKayKay]

Explanation for use of Terminate event in your project can be found in the VBA helpfile.
I suspect the QueryClose event likely to more appropriate for your requirement.

Dave

OKAY - will do.
Thank you again Dave. . .,