First off thank you for your help in advance.
I would like to use three different combo boxes to drill down into an analysis. Each combo box represents a level in a product hierarchy (For example, Department --> Category --> Subcategory). I would like the user to be able to select an option from the Department Combo box (i.e. Fruit) and then have just the categories for that department show up in the Category combo box (i.e. Apples, Oranges, etc.) and so on for the Subcategory combo box (i.e. Fuji apples, Golden Apples, etc.). I have already completed the part where once the users selects a subcategory, the sheet will populate with the data for that subcategory.
I am hoping there is a way to do this automatically instead of "hard coding" this in VBA. For example, an If statement saying if select Dept1, then show Category1, Category2, etc. This is just not doable with the amount of options available: 10 departments, 50 categories, and 400 subcategories.
Any ideas would be helpful.
I would like to use three different combo boxes to drill down into an analysis. Each combo box represents a level in a product hierarchy (For example, Department --> Category --> Subcategory). I would like the user to be able to select an option from the Department Combo box (i.e. Fruit) and then have just the categories for that department show up in the Category combo box (i.e. Apples, Oranges, etc.) and so on for the Subcategory combo box (i.e. Fuji apples, Golden Apples, etc.). I have already completed the part where once the users selects a subcategory, the sheet will populate with the data for that subcategory.
I am hoping there is a way to do this automatically instead of "hard coding" this in VBA. For example, an If statement saying if select Dept1, then show Category1, Category2, etc. This is just not doable with the amount of options available: 10 departments, 50 categories, and 400 subcategories.
Any ideas would be helpful.
