How do I keep the Excel UserForm from clearing when user Presses Done

**eemiller1997** · 11-26-2012, 09:53 AM

As I have tested my UserForm during its creation, I have noticed that when I press done and all of my contents are entered into the Excel worksheet and then re-open the UserForm it's blank! I don't want that. I want it to keep the information. How do I tell it to do that?

**Sean Thomas** · 11-26-2012, 10:04 AM

use
Me.Hide
or
Userform1.hide

this will hide your form with all its data
and when you call Me.show
it should all be there

**eemiller1997** · 11-26-2012, 10:11 AM

That sounds great. Thank you. Can you tell me where in the form's cod that should go. Should that go under the "done" button or somewhere else?

**Sean Thomas** · 11-26-2012, 10:21 AM

If you want the form to hide after you have run the code from your "done" button, just add me.hide as the last part of the code.

**eemiller1997** · 11-26-2012, 10:34 AM

I think I figured it out. I placed "me.hide" just above all of the code for where the contents should be placed onto the excel worksheet upon pressing done. When I tested it, it seems to have worked. Thanky ou!