Cascading Combo Boxes

pplstuff

Well-known Member
Joined
Mar 9, 2012
Messages
951
I'm looking to create cascading combo boxes. I do not want data validation, only combo box.

Essentially, I'm creating a dashboard based off a pivot table. I want to user to make selections on the Dash, and the PivotTable will adjust the report filters.

I've got everything all linked up, the only issue is the dependent combo boxes.

Ex.

Select Region {Africa, Asia, Europe, North America,...}

Depending on selection, Select Country [Africa] {South Africa, Congo, Egypt,...}

Select City ...

I've got a long bit of code that chops up data and creates named ranges/pivottables for everything. I'm just struggling on the cascading combo box since I can't use indirect().

Does anyone have any suggestions or helpful links? I've googled this for the last day or so and come across nothing beneficial. Thank you for your help. Excel 2007.


This was the most helpful link, but I don't want to use a userform - and "rowsource" isn't in the combobox properties.
Cascading Combo Boxes in Excel (Part II) « The Office Corner
 

Forum statistics

Threads
1,085,465
Messages
5,383,853
Members
401,858
Latest member
Nitsalet

Some videos you may like

This Week's Hot Topics

Top