userforms

[Randy]

I have a spreadsheet that uses userforms to input information along
with macros to move the data around. After the userform has been used
the data is cleared in the cells with a macro and the last command is
to hide the userform. When I re-activate the userform with a macro
the userform still has the information in it from the previous entry.
I can close the userform with the "X" in the top right corner and
re-activate again and the information is gone. I want the
information to be gone the first time I re-activate the userform.

 

[Chip Pearson]

Randy,

Unload the user form instead of just hiding it. E.g.,

Unload Me
' instead of
Me.Hide


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I have a spreadsheet that uses userforms to input information along
with macros to move the data around. After the userform has been used
the data is cleared in the cells with a macro and the last command is
to hide the userform. When I re-activate the userform with a macro
the userform still has the information in it from the previous entry.
I can close the userform with the "X" in the top right corner and
re-activate again and the information is gone. I want the
information to be gone the first time I re-activate the

userform.

 

[Bob Phillips]

Make the last command to Unload the userform not hide it. Hide retains it in
memory, unload doesn't.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)