Hi all,
I'm trying to combine two combo boxes in order to have them be dependent on each other:
e.g
combo box 1 has the following items:
Q1
Q2
Q3
Q4
combo box 2 has:
FY16
FY17
FY18
FY19
Now I want them to 'call' a certain Macro if FY16 AND Q1 are selected or the combination FY17 and Q2 etc. etc. The Macros that are supposed to be activated depending on these two combo boxes are fairly basic, but I couldn't figure out so far how to combine two different combo boxes, currently I am only using one combo box and my VBA codes look the following:
Code
Private Sub workbook_open()
ComboBox1.Clear
Sheet20.ComboBox1.AddItem "TOP DOWN"
Sheet20.ComboBox1.AddItem "BOTTOM UP"
Sheet20.ComboBox1.AddItem "BSR"
Sheet20.ComboBox1.AddItem "NOS"
Sheet20.ComboBox1.AddItem "CRU"
Sheet20.ComboBox1.AddItem "SPR"
Sheet20.ComboBox1.AddItem "SUM"
Sheet20.ComboBox1.AddItem "FAL"
Sheet20.ComboBox1.AddItem "HOL"
Sheet20.ComboBox1.AddItem "CRSPSU"
Sheet20.ComboBox1.AddItem "FAHO"
End SubCode
Private Sub ComboBox1_Change()
Select Case ComboBox1.Value
Case Is = "TOP DOWN"
TopDown
Case Is = "BOTTOM UP"
BottomUp
Case Is = "BSR"
BSR
Case Is = "NOS"
NOS
Case Is = "CRU"
CRU
Case Is = "SPR"
SPR
Case Is = "SUM"
SUM
Case Is = "FAL"
FAL
Case Is = "HOL"
HOL
Case Is = "CRSPSU"
CRSPSU
Case Is = "FAHO"
FAHO
End Select
End SubSo how would I now add the second combo box to it?? :duh: