Reset a VBA form in Excel

[irbk]

I have a VBA program writen in Excel. This program contains many userforms. I am wondering if there exists some kind of simple command to reset all the controls (check boxes, text boxes, radio buttions, etc) on the form. Any one know of a command to do that?

Thanks in Advance!

 

[PHV]

Unload UserFormName

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[irbk]

Thanks for the try. That just seems to unload the userform (not what I want to do). While it does accomplish clearing the form from the screen, that's more then what I'm trying to do. I basically just want to reset the form to the status it was when you first opened the form.

 

[PHV]

Sorry, I wanted to post this:
Unload UserFormName
UserFormName.Show

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[irbk]

Actually.... since I'm only running this while I'm closing one form and opening another.. the unload may just work afterall!