Combo Boxes in Excel

denise_z

Registered
I am trying to construct a form using combo boxes where by the second combo box shows choices based on what was chosen in the first combo box.

For example:

List 1 - holds a list conatanining wood, metal and plastic
List 2 - holds a list of different types of wood
List 3 - holds a list of different types of metal
List 4 - holds a list of different types of plastic

Now, when the user selects the first combo box on list 1, he gets presented with a list of 'Wood, Plastic, Metal, ... Etc. Let's say they select 'Metal'

They then select the second combo box and are presented with a list of Aluminium, Brass, Steel, ... Etc

Anyone have any idea how to achieve this?
 
Back
Top