Re: ComboBox dependant on the selection from preceding combo box/activate sheet based on selection
I know this question has been asked before but mine is a slightly different variation.
Here's what I'm trying to accomplish:
-Multi-sheet workbook
-Group and name specific sheets
-And specific group names to combo boxes
-And specific sheet names to combo boxes
-Activate/go to specific sheet from a combo box selection
-Hide all inactive sheets
-I do not want to use userforms or hyperlinks
-Button on every page that takes you to the “Home” page
-All sheets are to have the same combo box selections available so you can go to any sheet from where ever you currently are without having to go back to the “Home” page
Example:
Work Sheets: 1,2,3,4 named Group1
Work Sheets: 5,6,7,8 named Group2
Work Sheets: 9,10,11,12 named Group3
Work Sheets: 13,14,15,16 named Group4
Work Sheets: 17,18,19,20 named Group5
Work Sheets: 21,22,23,24 named Group6
-Cmbobox1 should have specific group names listed:
Example:
Cmbobox1 = Group1
Group2
Group3
-Cmbobox2 list is dependent on selection in cmbobox1
Example:
Cmbobox1 selection = Group2
Cmbobox2 list = 5,6,7,8
-When selection in cmbobox2 is made, go to the sheet that was selected
Example:
Cmbobox2 = 6, go to sheet 6