Dependent comboboxes

Hi,

This should get you started although the data validation would be just as easy. The ListFillRanges are the cities you want. The code goes into ComboBox1.

Private Sub ComboBox1_Change()
If ComboBox1.Value = "California" Then
ComboBox2.ListFillRange = "N10:N11"
End If
If ComboBox1.Value = "Massachusetts" Then
ComboBox2.ListFillRange = "O10:O11"
End If
If ComboBox1.Value = "Rhode Island" Then
ComboBox2.ListFillRange = "P10:P11"
End If
End Sub

You could also use SELECT/CASE arguments.

HTH
Steve

jefferybrown:

Yeah, I strongly prefer comboboxes because my department is most certainly not computer savvy, to the extent where I'd rather not even have anything remotely hidden (such as the data validation arrows). The worksheet I attached will be part of a shared database so I'm making it as user-friendly as possible.


SteveG:

Let me try those, since what's also important is that it still works after I add more company information to the "Data" sheet.

Edit: I looked over the code one more time and realized that having to manually name all the entries wouldn't fly too well with the constant adding of information and as well as the whole user-friendly theme. I guess I was looking for something more automated. For example, if I were to enter another company under the state of California or a new state altogether, then the comboboxes return the data accordingly.


Thanks guys for the help so far!