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