Limiting Entries in A List Box

I'm using a list box so the user can select the player name when entering
team members on a score sheet (sheet 1). The list box range is connected to
the Player Details (sheet 2) and displays all players irrespective of the
team they play for. Using the team name (sheet 1) I want to limit the
players shown in the list box to only those of that team. Sheet 2 contains a
list of the players with a unique player number, their name and the team they
are on.

I'd be grateful to receive suggestions as to whether this is possible and if
it is, how to achieve it.

Thanks,

Dave

Hi
Take a look at Debra Dalgleish's site for lots of help with this type of
problem

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

--
Regards

Roger Govier


Dave C <DaveC@discussions.microsoft.com> wrote
> I'm using a list box so the user can select the player name when
> entering team members on a score sheet (sheet 1). The list box
> range is connected to the Player Details (sheet 2) and displays all
> players irrespective of the team they play for. Using the team
> name (sheet 1) I want to limit the players shown in the list box to
> only those of that team. Sheet 2 contains a list of the players
> with a unique player number, their name and the team they are on.
> I'd be grateful to receive suggestions as to whether this is
> possible and if it is, how to achieve it.
> Thanks,
> Dave