Remove item from list after selecting

[murphyjones]

I am trying to create an NFL pick'em program for some the upcoming season. I am trying to do this using combo boxes. The rules are that you can only use a team once until you have used every team. I can't figure out how to set up the combo box to remove the selected team from the list. There will be several players, so each list of available teams will be different. If someone can help me set it up for 1 user, I can so the rest for the other players. Is this possible to do without combo boxes, ie. just by typing in the team excel will check if that team has been selected an bring up a message prompting an error. There will be 3 picks per week, so week 11 pick 3 will have all teams available. Thanks for the help!

[kadghar]

to remove an item from a combo box, just remember

combobox1.list(n) will select the (n-1)th item, since the indexes start from zero.

Combobox1.listindex is the selected item... so just add to a sub:

combobox1.list(combobox1.listindex).delete

and you're done eliminating the selected item ^.^

[Killer42]

I believe this is version-specific. If you happen to be using VB6 (or earlier), you would use the ComboBox.RemoveItem method.