How do you reset a userform?

[Guest]

I have a userform that runs great, but when I go back to use again it still has the information in the form from the last time. How do I clear it I want the check boxes reset to the orginal status and othe command boxes reset to look like the userform that I created

TIA

 

[Greg Wilson]

Are you hiding it or unloading it when you close it?

-----Original Message-----
I have a userform that runs great, but when I go back to

use again it still has the information in the form from
the last time. How do I clear it I want the check boxes
reset to the orginal status and othe command boxes reset
to look like the userform that I created.

 

[Guest]

I am hiding it

----- Greg Wilson wrote: ----

Are you hiding it or unloading it when you close it

-----Original Message----
I have a userform that runs great, but when I go back to

use again it still has the information in the form from
the last time. How do I clear it I want the check boxes
reset to the orginal status and othe command boxes reset
to look like the userform that I created

 

[Vasant Nanavati]

There's your answer, then!

--

Vasant

I am hiding it.

----- Greg Wilson wrote: -----

Are you hiding it or unloading it when you close it?


use again it still has the information in the form from
the last time. How do I clear it I want the check boxes
reset to the orginal status and othe command boxes reset
to look like the userform that I created.

 

[Greg Wilson]

You need to unload it instead of hiding it:
"Unload Me" instead of "Me.Hide". If it's too slow
unloading you can hide it first and then unload it while
it's hidden.

Regards,
Greg

 

[JE McGimpsey]

An alternative would be to store the default settings, either in VBA or
on a worksheet, and use a Sub to restore them.

 

[Guest]

The great thing about these borads is the fact that people answer you and let you know what to do.
Thanks everyone for your help.