ComboBox dependant on the selection from preceding combo box

[dan_h]

Any idea how to create a combo box that changes it's list depending upon what was selected in the the combo box just before?

 

[Andrew Fergus]

Hi
This question has been asked a few times before, there are some resources here that might help you :

http://www.mrexcel.com/board2/viewtopic.php?t=94118

http://www.fontstuff.com/access/acctut10.htm

HTH, Andrew

 

[dan_h]

Andrew, thanks a lot. I tried to search the board for an answer...sorry for that. Like the initial replier in the link, it looks like a lot but I'll give it a try. I'm pretty excited since I am just a causual user and this is outside my comfort zone. -Dan

 

[Andrew Fergus]

Hi Dan
The second link might be easier to follow because it steps you through the process from the beginning.
Andrew

 

[dan_h]

Very cool, I used the second link and walked through the examples. It made perfect sense so now I'll just apply it to my database. Really appreciate the help!

 

[MacFarlanep]

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