Hi all,

I am working on a soccer form and currently have 2 comboboxes (alon
with other controls) on a userform named comTeam1 and comTeam2 . The
are both populated with the same list of teams as the workbook opens.

Since a team cannot play against itself I would like to remove the tea
chosen in comTeam1 from comTeam2 when comTeam1 is changed.

I have tried:

Private Sub comTeam1_Change()
comTeam2.RemoveItem comTeam1.Value
End Sub

but this gives me an invalid call error. I would be grateful for som
help in this direction.

Many thanks

Seamu

--
SO
-----------------------------------------------------------------------
SOS's Profile: http://www.excelforum.com/member.php...nfo&userid=540
View this thread: http://www.excelforum.com/showthread.php?threadid=26314