3 listboxes, 1 txtbox and 1 cmdbtn.

listbox1 contains PLAYERS name
listbox2 is for TEAM name for the players
listbox3 is for PLAYERS name of the particular team name selected o
listbox2

Among all listboxes, only listbox1 is multi-select.

Now what i require is...
Upon selection in listbox1 for the number of players, 1 team name i
accepted by the user from txtbox. On clicking cmdbtn, team name i
added in listbox2 and its player names selected in listbox1 are adde
in listbox3.

On selecting team name in listbox2, it must show players name i
listbox3 of only particular team name selected.

Pl.note:
1- listbox2 must not accept duplicate name for creating team name.
2- It must only accept to generate team only if user select players i
listbox1.
3- It must not accept if any selection in listbox1 matches any player
in listbox3 of already created teams

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=46777