What is the difference in unload userform and userform.hide?
Thanks

Hi Randy,

Unload deletes the Userform from memory;
hide rmerly hides the Userform but retains it
in memory. Thus, with unload, any user data
inserted in the form will be destroyed; with
hide any such data will be available the next
time that the fotm is shown in the current
Excel session.


---
Regards.
Norman
"randy" wrote in message
...
What is the difference in unload userform and userform.hide?
Thanks

When you unload a UserForm, all of the values for the controls on the form
are emptied and become inaccessible. If you hide the form, you still have
access to the values of the controls.

"randy" wrote:

What is the difference in unload userform and userform.hide?
Thanks