Excel Dependent Combo Boxes

           Excel Dependent Drop Down Lists

In this example, we will create a userform that contains dependent combo boxes and a textbox. We will use  this userform to enter the data  into cells as fastly.

The UserForm will be opened automatically when any cell in "Column A" is selected.

The important point in this template ; by creating a dependency between combo boxes,  selectively choices can be limited.