What is a UserForm in Excel?

Add to Favorites
Author: | Edits: don

A UserForm is basically a pop-up window that you can use to create a custom interface for Excel.

This pop-up window allows you to have a more user-friendly interface and to automate Excel in many ways using VBA and macros. In the pop-up window, you can have many different kinds of buttons, user input areas, and layouts.

A UserForm creates a visual interface but, behind it all, is the code that runs it, the VBA and macros. When you click a button within a UserForm, you are causing a piece of code to run. This code can be placed wtihin the UserFrom itself or within regular modules with other macros. This particular concept might be confusing for now, but keep reading the tutorials and you will quickly understand the concept.

Here is a screenshot from a UserForm that we create in the Make a UserForm in Excel tutorial.


The UserForm in this photo allows someone to enter data into the pop-up window and then, when the Show Text button is clicked, that input is stored into cell A1 on the spreadsheet.

This is a very simple example, but it shows you a few key things:

  • UserForms make the input and display of data clean and easy-to-understand.
  • UserForms seamlessly interact with worksheets and can be used to put data into and get data from them.
  • You can customize just about every part of a UserForm to get it to look like you want and say what you want.

UserForms are a seemingly advanced topic in Excel, but, as you will see from our tutorials, they are not difficult to create and maintain.

Relax, open up Excel, and let's get started!

Question? Ask it in our Excel Forum

Our Excel Courses

  • 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.

  • 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
What is a Macro in Excel?
Tutorial: This is the first step to learning about Macros for Excel and how to use them.  What is a...
Get Data from the Worksheet into a Macro in Excel
Tutorial: Here, you'll learn how to get information from the Excel worksheet into a macro so you can...
Make a UserForm in Excel
Tutorial: Let's create a working UserForm in Excel. This is a step-by-step tutorial that shows you e...
Dates in Excel Explained
Tutorial: I'll explain how dates in Excel work and then point you to many useful tutorials on how t...
Showing a UserForm
Tutorial: How to display a UserForm in Excel and some common things you might want to do when you di...
Closing a UserForm
Tutorial: How to close a UserForm in Excel. This includes hiding the form as well as completely clos...