Dear Excel experts,

Does clicking the Close button of a Userform actually unload the object
(like Unload Userform1) or do I have to use the Unload statement to actually
remove it from memory?

Regards,

Jan Bart

Hi Jan,

Closing a Userform with the little x button does appear to fully unload the
form from memory, assuming you have not interrupted in the QueryClose event
and done something else.

If you had set a global object reference to the form, after closing with the
little x the object ref remains "Not Nothing" even though no form properties
persist. However you would still want to set any object ref to Nothing.

Regards,
Peter T

"Excelerate-nl" wrote in message
...
Dear Excel experts,

Does clicking the Close button of a Userform actually unload the object
(like Unload Userform1) or do I have to use the Unload statement to
actually
remove it from memory?

Regards,

Jan Bart