combo list box help

[jtb210]

how do i create combo list box that is A. searchable B. auto complete C. removes selections.

sheet team brooks
[TABLE="width: 398"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 5"]Brooks[/TD]
[/TR]
[TR]
[TD]Pick[/TD]
[TD]Roster[/TD]
[TD]Player[/TD]
[TD]Team[/TD]
[TD]Bye Week[/TD]
[/TR]
[TR]
[TD]Pick #20[/TD]
[TD]QB[/TD]
[TD]Chad Henne[/TD]
[TD]Baltimore Ravens[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]QB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]RB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]RB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Pick #1[/TD]
[TD]WRorTE[/TD]
[TD]A.J. Green[/TD]
[TD]Cincinnati Bengals[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]WRorTE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]WRorTE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]WR/TE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]K[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]DEF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]



i have a group of players by position which is index listed off of position selected on brooks sheet list.

not too familiar with macros.

 

[jtb210]

Anyone?