Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
comboBoxes on a userform
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
comboBoxes on a userform
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 = "D5:D6" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify code to Add ComboBoxes instaed of Textbox values on Userform ? | Excel Programming | |||
Userform Comboboxes - need a quick how to.. | Excel Programming | |||
ComboBoxes | Excel Programming | |||
Multiple ComboBoxes and TextBoxes on Userform | Excel Programming | |||
Several comboBoxes on a Userform | Excel Programming |