ComboBox on a UserForm
 

Good Morning.

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

ComboBox on a UserForm
 

Not sure how proficient you are in VBA. I am just learning but I had to do
the something similar. Basically, you will need to populate the facility
list combobox on change of combobox1 by matching the district picked to the
same value either by SELECT CASE (if small list) or to a list on a worksheet,
then populating the facility combobox when match found. I used a list on a
worksheet since my list can be added to. I don't have the code I used in
front of me.

Hope this helps,
Les

"LLoyd" wrote:

Good Morning.

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

ComboBox on a UserForm
 

Resolved!!
http://www.microsoft.com/office/comm...sloc=en-us&p=1



--
RyGuy


"WLMPilot" wrote:

Not sure how proficient you are in VBA. I am just learning but I had to do
the something similar. Basically, you will need to populate the facility
list combobox on change of combobox1 by matching the district picked to the
same value either by SELECT CASE (if small list) or to a list on a worksheet,
then populating the facility combobox when match found. I used a list on a
worksheet since my list can be added to. I don't have the code I used in
front of me.

Hope this helps,
Les

"LLoyd" wrote:

Good Morning.

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