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.

658a01014e93a1d0d2233d8845cece5f.jpg

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


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 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

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...
Tutorial Details
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