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.

Sections:

Reset UserForm

Notes

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

UserForm1.Show

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.

f09713815930348f3e185c31b2b7a5ba.png

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

0fdc29d8e65c95ec72cc72827c35c106.png

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.

Notes

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.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Loop Through Controls in a UserForm
Tutorial: How to loop through all controls in a UserForm; this allows you to do things like get valu...
Add Values to a ListBox
Tutorial: How to fill a Listbox with values in a UserForm. By default, a Listbox in a form will be e...
Count the Number of Unique Values in a List in Excel
Tutorial: Use a formula to count the number of unique values that are contained within a list in Exc...
Delete All Comments in a Worksheet in Excel Macro
Macro: Excel macro that will delete all of the comment contained within the active or current wor...
Add Values to a ComboBox
Tutorial: Add values to a ComboBox in a UserForm in Excel. There are 3 simple ways to add values, tw...
Highlight Duplicate Values in Excel
Tutorial: How to highlight duplicate values in a list. Also, how to arrange those values next to ea...
Tutorial Details
Downloadable Files: Excel File
Similar Content
Loop Through Controls in a UserForm
Tutorial: How to loop through all controls in a UserForm; this allows you to do things like get valu...
Add Values to a ListBox
Tutorial: How to fill a Listbox with values in a UserForm. By default, a Listbox in a form will be e...
Count the Number of Unique Values in a List in Excel
Tutorial: Use a formula to count the number of unique values that are contained within a list in Exc...
Excel Forum