Good Day.

I have done many comboBoxes on a userform, but now I now I need one comboBox
to look at another.

E.G
comboBox 1 has the district listed
comboBox 2 has the Facility listed
When you choice a district in comboBox1, then only the facilities belonging
to that district should show in comboBox 2.
On a sheet I do have the list of all the Districts in one col and list of
districts to Facility in two other col.

Thanks for your help

hi
what you described sounds like cascading combos sometimes call dependent
combos. works something like this....
Private Sub ComboBox1_Change()
If Me.ComboBox1.Value = "1" Then
Me.ComboBox2.RowSource = "B5:B6"
Else
Me.ComboBox2.RowSource = "D56"
End If
End Sub
this sample code is for a two option combo box. if you have more options
then add more ifs for the additional options.

regards
FSt1

"LLoyd" wrote:

> Good Day.
>
> I have done many comboBoxes on a userform, but now I now I need one comboBox
> to look at another.
>
> E.G
> comboBox 1 has the district listed
> comboBox 2 has the Facility listed
> When you choice a district in comboBox1, then only the facilities belonging
> to that district should show in comboBox 2.
> On a sheet I do have the list of all the Districts in one col and list of
> districts to Facility in two other col.
>
> Thanks for your help
>