| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clearing/Resetting UserForm Values
unload Userform1
-- Regards, Tom Ogilvy "Rob" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clearing/Resetting UserForm Values
Out-Freakin-Standing!! It works perfectly.
"Tom Ogilvy" wrote: unload Userform1 -- Regards, Tom Ogilvy "Rob" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| resetting excel to default values | Excel Discussion (Misc queries) | |||
| Clearing a textbox in userform | Excel Programming | |||
| Clearing the Values in a Drop - Down List | Excel Programming | |||
| Resetting values based on change in cells of other column | Excel Discussion (Misc queries) | |||
| Clearing a userform | Excel Programming | |||
Linear Mode
