Clearing/Resetting UserForm Values
I have a sub, when it is activated it shows a form and it collects info that
the user provides in the form. When the Sub is done running I want to
clear/reset the form back to it's unpopulated state so that the next time it
is run the form is empty. How in the world do I do this?
Application.UserForm1.Reset ?
Application.UserForm1.Clear ?
Application.UserForm1 = Nothing ?
UserForm1.Clear ?
UserForm1.Reset ?
Thanks bunches.
Rob
|