Home > Macros >UserForms

Excel UserForm Topics

See how to get started with Excel UserForms, or find new features you can add to existing UserForms. For example, enter data in a list that is on a different worksheet, or activate a specific tab automatically, when the UserForm opens.

Get Started: UserForm with TextBoxes

In the screen shot below, there is a worksheet button that opens a simple data entry UserForm.

Fill in the text boxes, then click the "Add this part" button, to send the data to a table on a hidden worksheet.

UserForm with TextBoxes and worksheet button

This video shows how that simple Data Entry UserForm works.

There are step-by-step instructions and videos on the Create a UserForm with Textboxes page, and you can download the Excel workbook for this project

Excel UserForm with Comboboxes

This video shows how you can use comboboxes in a simple Data Entry UserForm, to make it even easier to enter data. Choose items from a drop down list, instead of typing. This also helps to prevent data entry errors, because people choose from the list of valid items.

Excel UserForm Test

There are step-by-step instructions and videos on the Create a UserForm with Comboboxes page, and you can download the Excel workbook for this project

Change ComboBox Settings

After you create a ComboBox on an Excel UserForm, you can change its settings, to enhance the ComboBox. For example, show a heading for each column in the ComboBox, to make it easier to understand.

.There are step-by-step instructions on the Create a UserForm Combobox Tips page, and you can download the Excel workbook with the examples

first row shown as column heads

Dependent Comboboxes

This video shows how use dependent combo boxes on a UserForm. Choose an item from the first combobox, and the second combobox shows a list of items that relate to your selection.

For example:

  • Choose handle in the Part Type drop down.
  • The second combobox, for Part ID, shows a list of parts that are handles.

Excel UserForm Test

There are step-by-step instructions on the Dependent Combobox page, and you can download the Excel workbook with the example

UserForm With Help Pages

This video shows how to create a simple UserForm with a MultiPage control, where you can add help messages. The workbook's sheets have Help buttons, and they open the UserForm, to the related page in the MultiPage control.

For example, if you click the Help button on the PivotSales worksheet, the UserForm opens with the Pivot tab active in the UserForm.

.There are step-by-step instructions on the UserForm Help Pages page, and you can download the Excel workbook with the example

Related Tutorials

Basic UserForms - Videos

UserForm with ComboBoxes

UserForm Dependent ComboBoxes

UserForm ComboBox VBA

UserForm TextBox Validation Code

UserForm with Help Pages

 

Last updated: February 17, 2024 2:22 PM