View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default 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