Excel UserForm with Dependent Combo Boxes

In an Excel UserForm, you can add combo boxes to make data entry easier.

The UserForm in this example is used to enter parts information onto a hidden inventory sheet.

Before selecting a Part ID, you have to select a Part Type. When the Part Type combo box is updated, code runs, and creates a list of parts, for the selected part type.

How It Works

In the background, an Advanced Filter runs, to create a worksheet list of parts for the selected part type.

That list is set up as a named range, and the range name is used as the Part ID combo box row source.

Watch the Video

To see how the dependent combo boxes work, watch this short video.

Video Timeline

• 0:00 UserForm Demo
• 0:53 Lookup Lists Sheet
• 1:25 See How Macro Works
• 1:48 Named Range for Parts List
• 2:02 UserForm Macro Code

Download the Sample File

To test the dependent combo boxes on the UserForm, and to see the code, go to my Contextures website, and download the sample file.

_______________