How select an item in a list box
 

How do I use one list box to let me select one item in the list and get
Excel to display names related to this item in a second list box, i.e.
choose the name of a football team from one list box and display all
the playes from that team in a second list box. I then need to select
a player to display details about that player in a separate cell.

Any help would be appreciated. Thanks. Jamie81


--
jamie81
------------------------------------------------------------------------
jamie81's Profile: http://www.excelforum.com/member.php...o&userid=18516
View this thread: http://www.excelforum.com/showthread...hreadid=375168

See http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

"jamie81" wrote in
message ...

How do I use one list box to let me select one item in the list and get
Excel to display names related to this item in a second list box, i.e.
choose the name of a football team from one list box and display all
the playes from that team in a second list box. I then need to select
a player to display details about that player in a separate cell.

Any help would be appreciated. Thanks. Jamie81


--
jamie81
------------------------------------------------------------------------
jamie81's Profile:
http://www.excelforum.com/member.php...o&userid=18516
View this thread: http://www.excelforum.com/showthread...hreadid=375168