Hi,

I have a spreadsheet that when you click on a 'Form Macro'
a user form appears but it always has the old info in the
text box I want all field cleared for the user to fill

Glenn,

This is probably because the macro does a form.Show which just shows the
form if it is already in memory, which will be true if it is 'closed' with a
form.Hide rather than Unload form.

The best thing is to add code to the Userform_Activate event to clear it

Textbox1.Text = ""

--

HTH

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

"Glenn" wrote in message
...
Hi,

I have a spreadsheet that when you click on a 'Form Macro'
a user form appears but it always has the old info in the
text box I want all field cleared for the user to fill