Deleting items from a combobox

[SOS]

Hi all,

I'm currently trying to produce a userform for a friend that has two comboboxes (among other controls) The two comboboxes show teams which play each other in football games.

I can populate the comboboxes on UserForm_Initialize but my problem is that when a team is chosen from Combo No 1 I want that entry to be removed from Combo No 2 (as a team cannot play against itself).. Can anyone point me in the right direction for the code to achieve this?

Many thanks in advance

Seamus

[SOS]

I managed to work it out.

My comboboxes are named comTeam1 and comTeam2 and I have used the following code:

Private Sub comTeam1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
comTeam2.RemoveItem comTeam1.ListIndex
End Sub

and that works just fine.

Regards

Seamus