Home |
Search |
Today's Posts |
#1
|
|||
|
|||
2 combo boxes
I have 2 combo boxes and depending on the choice in combo 1 I want combo 2
box to change choices. Is this possible. thx, greg |
#2
|
|||
|
|||
Using VBA you can specify the ListFillRange for ComboBox2.
Private Sub ComboBox1_LostFocus() If ComboBox1.Value = "Option1" Then ComboBox2.ListFillRange = "B1:B3" ElseIf ComboBox1.Value = "Option2" Then ComboBox2.ListFillRange = "C1:C3" ElseIf ComboBox1.Value = "Option3" Then ComboBox2.ListFillRange = "D1:D3" End If End Sub You can also clear the CB2 displayed entry when selecting CB1 with this Private Sub ComboBox1_GotFocus() ComboBox2.Value = "" End Sub otherwise CB2 continues to display the last selected item until you change it. Ian "Greg" wrote in message ... I have 2 combo boxes and depending on the choice in combo 1 I want combo 2 box to change choices. Is this possible. thx, greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Drop Down Boxes | Excel Worksheet Functions | |||
limiting combo box entry | Excel Worksheet Functions | |||
dynamic combo boxes | Excel Worksheet Functions | |||
combo boxes in pocket excel | Excel Discussion (Misc queries) | |||
How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions |