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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Ronanm

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

Well-known Member
Joined
Jan 11, 2012
Messages
4,066
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
 

Ronanm

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

Watch MrExcel Video

Forum statistics

Threads
1,122,464
Messages
5,596,288
Members
414,052
Latest member
Dual Showman

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
Top