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