UserForm Level Variables Scope Question

[cr731]

I have several variables declared at the top of my UserForm (outside of any procedure), some of them are ranges, ListObjects, and PivotTables. Is it necessary to use

Set variable = nothing

before closing the UserForm to remove them from memory, or will they automatically go out of scope when the UserForm is closed - by clicking the X on the upper-right of the UserForm?

My understanding was that UserForm level variables are similar to Module level variables, and I was reading here (http://www.ozgrid.com/VBA/variable-scope-lifetime.htm) and it sounds like Module Level variables are retained until the Workbook is closed or End is used;


"Its value is retained unless the Workbook closes or the End Statement is used."

But I'm still not positive this is exactly the same as a UserForm.

 

[shg]

They are local to the instance of the form, so they are destroyed when it is closed (not Hidden).