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