MrExcel Publishing
Your One Stop for Excel Tips & Solutions

cascading combo boxes

Posted by Gurpal on February 16, 2002 4:33 AM

is there any way in which i can make the choice of 1 combo box effect a 2nd combo box. In other words, the second is dependant on the second

Posted by Tom Morales on February 17, 2002 6:25 AM

Gurpal - I guess the short answer is yes. You can do something like:
Private Sub ComboBox1_Change()
ComboBox2.Value = ComboBox1.Value
End Sub
I imagine you have something more complicated in mind. You may get the idea, from the example.