data in form Combobox2 depends on selection from Combobox1

mtk1985

New Member
Joined
Apr 22, 2014
Messages
7
Hello,

I need some help with combobox's.. I have it working as I need it to with Active-x combobox but I need to move to a form method because the Active-x combobox is buggy in the worksheet and has these strange font and box resizing issues which there is no solution to out there.. Something about if you have external monitor or projector plugged in and it using a different resolution to what your native laptop or pc is using.. doesn't make any sense to me and unfortunately I have given up on it.

Problem is what I want doesn't seem like it can be done with form combobox but I will seek your support first before I come to that conclusion.

So using form Combobox, this is my setup:

Combobox1 contains a short list of Teams i.e. ENT,MEL,EMEA,MTVSSL,TSJ -- I am referencing this from the FORMAT CONTROL property Input Range: TEAMS!A2:A6
Combobox2 I need to list the names of the people in those regions i.e. John Doe etc.. I have column with regions as headers and the people in each column in the respective region. i.e. B1:B16 has the list of people for the team called ENT (B1 is the header "ENT") and B2:B16 is the names of the people.

Problem is I don't know how I can link the two based on selection in Combobox1?

One catch, I prefer not to hard code the names of people in any code, if I can reference from a table or cell that would be better as the list of people within a team will increase over time.

As always, appreciate anyone's guidance.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top