So to clear the data that was entered and to use the .hide,
The userform should be coded to clear all values upon Initializing to
remove any values that were entered previously if the userform is then
re-.shown?

Corey....
"Nick Hodge" wrote in message
...
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....