Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Reset All Values in a UserForm

Add to Favorites
Author: | Edits: don

Clear or reset all values in a UserForm so that they contain only the default original values.

This method will remove all input and selections made by the user.


Reset UserForm


Reset UserForm

To do this, we simply close the form and then reopen it. This is the easiest way to completely reset the form and go back to the original values for each control.

Unload Me


The first line removes the UserForm and the second line makes it reappear.

UserForm1 is the name of the form that you want to show. You get this from the (Name) section of the Properties window when you select the form.

You can use the above code however you like, but it is often attached to a button within the UserForm.


In this example, double-click the Reset Form button and place the code within the code section that appears for this button:


The name of the Reset Form button is CommandButton3.

Now, we have a button in the form that will reset everything back to the way the form was when it was originally opened.


When you use this method to clear/reset a form, you will see the window flicker; that is just the current form being closed and then re-opened again.

Make sure to download the attached file to get this example in Excel.

Question? Ask it in our Excel Forum

Downloadable Files: Excel File