combobox

F

flow23

Hi
I have four combobox's
what I want is when the user selects one of them.. the values in the other
should change accordingly.

what is the best way to do this?
 
R

Roundy

Here is an example of somethign I did where based on a value in a name range
it would populate the combobox from different sets of values which are also
name ranges. This was done on a form. There is a value property of a
combobox that you would check the value on to determine what your
rowsource(list of values) will be.

If Range("PumpMfgValue").Value = "HydroFlo" Then
CmbxPumpModel.RowSource =
Range("HydroFloPumpModels").Address(external:=True)
ElseIf Range("PumpMfgValue").Value = "Goulds" Then
CmbxPumpModel.RowSource =
Range("GouldsPumpModels").Address(external:=True)
ElseIf Range("PumpMfgValue").Value = "American Turbine" Then
CmbxPumpModel.RowSource =
Range("AmericanTurbinePumpModels").Address(external:=True)
Else
Exit Sub
End If
*****************************************
Yours might look something like this

ComboBox1.RowSource =
Range("listofvaluesforcombobox1").Address(external:=True)
If Combobox1.Value = "???????" Then
Combobox2.RowSource = Range("????????").Address(external:=True)
ElseIf Combobox1.Value = "???????" Then
Combobox2.RowSource = Range("????????").Address(external:=True)
End If
 
Top