Linking Two Combo Boxes

[Salza]

Hello all,

I have a list of data in a Combo Box A in Sheet 1.

The data in Combo Box A is as following:-

1) Liverpool
2) Man Utd
3) Chelsea

Now, I want one more combo box (i.e. Combo Box B) in front of Combo
Box A.

If I select Liverpool in Combo Box A, then automatically a list of
Liverpool players appears in Combo Box B. And if I select Man Utd in
Combo Box A, then automatically a list of Man Utd players appears in
Combo Box B and so on.

Can this be done? Please help me show how to go about it. Thanks.


Zainuddin

 

[Per Jessen]

Hi again,

Debra Dalgleish show how to do it on this site:

http://www.contextures.com/xlDataVal02.html

Regards,
Per

 

[Salza]

Hi again,

Debra Dalgleish show how to do it on this site:

http://www.contextures.com/xlDataVal02.html

Regards,
Per

Thank you so much, Per, for the website.
It helps me a lot with that.