Combo box showing values based on another combo box selection

Ronanm

Board Regular
Joined
Nov 13, 2010
Messages
107
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
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
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
 
Upvote 0
for example, in the initialize script of the userform, you can use
Code:
ComboBox1.RowSource = Range("A8").Value
assuming the range name is in cell A8
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top