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?

Where are you getting the values? on a sheet somewhere?

"flow23" wrote:

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?

yes

"Roundy" wrote:

Where are you getting the values? on a sheet somewhere?

"flow23" wrote:

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?

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(externa l:=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

"flow23" wrote:

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?