Run code on closing a form

[daseffects]

I want to set Excel calculation back to automatic when the my form closes as I do when it launches.


I use Userform_activate() when the form launchs but have tried terminate and exit w/ no luck.



Application.Calculation = xlCalculationAutomatic

 

[SQLBI]

daseffects,

I've not tested this, but UserForm_Terminate() may be what you're looking for.

Hope this helps.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk