Corey
Hide is the only way to dismiss the form and persist the data, Unload
removes it from memory and returns the controls to their design time state
and it cannot be read
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"Corey" wrote in message
...
What is the best way to close off a userform without unloading the data.
Userform.hide simply hides the userform,
but is this good enough as a close?
As it still stores the data in the userform if something was placed there.
Corey....