Hi
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 |
Hi
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 |
All times are GMT +1. The time now is 01:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com