VB to Reset userform to blanks

keith · Mar 6th, 2002, 03:28 PM

Custom form called by a command button on sheet. After form is sucessfully called, filled out and submitted the data adds to my list. The next time the form is called it is prefilled out with the values of the last time it was used. I need the form to be blank each time is it called.. I assume I can put a "reset" statement before the UserForm1.Hide at the end of the form but I dunno the syntax.. THANKS!

Mark O'Brien · Mar 6th, 2002, 03:31 PM

Quote:

On 2002-03-06 14:28, keith wrote:
Custom form called by a command button on sheet. After form is sucessfully called, filled out and submitted the data adds to my list. The next time the form is called it is prefilled out with the values of the last time it was used. I need the form to be blank each time is it called.. I assume I can put a "reset" statement before the UserForm1.Hide at the end of the form but I dunno the syntax.. THANKS!

Try using:



Unload Userform1

This destroys the form instead of just hiding it. This will reset the form.

Cheers

keith · Mar 6th, 2002, 03:37 PM

perfect thanks..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 03:28 PM	#1
keith Board Regular Join Date: Mar 2002 Posts: 88	Custom form called by a command button on sheet. After form is sucessfully called, filled out and submitted the data adds to my list. The next time the form is called it is prefilled out with the values of the last time it was used. I need the form to be blank each time is it called.. I assume I can put a "reset" statement before the UserForm1.Hide at the end of the form but I dunno the syntax.. THANKS!

Mar 6th, 2002, 03:37 PM	#3
keith Board Regular Join Date: Mar 2002 Posts: 88	perfect thanks..