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
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