Combo box showing values based on another combo box selection

[Ronanm]

Hi

Without using VBA, I would like to have a Combo box showing values based on another combo box selection.

E.G. The 1st box would have a list of Countries and when Country was selected, then the 2nd Combo box would show the appropiate Cities for that Country only.

I have tried listing each Country in a column with theier Cities next to them, and named the City ranges by their corrosponding Countries, but can't seem to get the 2nd Combo to refer to the "Input Range" using a "cell value".

E.G. I would select Uk from the 1st Combo, and using the Cell Link, I would have the number going into a cell, then I'd use the Index fuction to display the Country e.g. "UK" in a cell, but cannot get the 2nd Combo to display the Cities, using a named range based on the Country value I recieved from the cell using the Index Function.

If that make sense

Ronan

 

[Dryver14]

Have a look here, It should help:

Excel Data Validation -- Dependent Lists

 

[Ronanm]

Thanks... Looked at that today but I need to use Combo boxes, not validation.

Can you refer to a cell e.g. "A1" where a range "name" resides, as an "Input Range" of a combobox

Thanks

 

[Momentman]

for example, in the initialize script of the userform, you can use

ComboBox1.RowSource = Range("A8").Value

assuming the range name is in cell A8

 

[Ronanm]

Doh! Actually...

It's a "DropDown" box on the spreadsheet from the Forms toolbar, which didn't let me use the "Rowsource" as above..

Thanks