Linking drop down boxes

Walk through ContaminateWitExcel's example as you read this...
For the first combo box, Right click and choose Format Control and then the Control Tab.

Input Range = Range of master list (or name of master list if using defined names)
Cell Link = cell where you want output (outputs the number of item you choose, eg. 1 for 1st entry, 2 for 2nd. For consistancy we'll choose M17

Next go to your Define Names window (Insert>Names>Define). For every item in your 1st combo list, name a range corresponding to the options for that list. Names cannot have blank spaces.

Next, set up the DependentDropDown name (choose any name) in the Define Name Window. This will be

=OFFSET(ITEM1, M17-1)

where you replace ITEM1 with the name you chose for your first item in your combobox 1. In Cont.wExcel example, that was Azerbaijan.

Next, right click on combobox 2, Format Control>Control Tab and for input range, put the name you cose for DepenedentDropDown name.

I think I got everything. Normally, I put the output of the Combobox 1 directly underneath the combobox as no one needs to see that number.

Clear as mud?

see file please

I think that Contaminated used Forms Combo Boxes and you used an Active X Combo box. Can you switch? Can you upload an example of your workbook?

In Excel 2007, The "Define Name" options are on the Formulas Ribbon. To view Contaminated's defined names, use the "Manage Names" Icon. Does that help?