Removing item from combobox with vba

[SOS]

Tom,

The comboboxes are populated during the UserForm_Initialize() event:

Private Sub UserForm_Initialize()
With comTeam1
.AddItem "Airdrie"
.AddItem "West Lothian"
End With - (many more teams in the real sheet)

With comTeam2
.AddItem "Airdrie"
.AddItem "West Lothian"
End With - (many more teams in the real sheet)
End Sub

So I felt that during the code I could use something like:

"comTeam2.RemoveItem comTeam1"

Thanks

Seamu

 

[Tom Ogilvy]

You can, but removeitem requires an index

comTeam2.RemoveItem comTeam1.ListIndex