VB to Reset userform to blanks

[keith]

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]

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:

<pre>
Unload Userform1
</pre>

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

Cheers

 

[keith]

perfect thanks..