Removing a selection/choice from a listbox once the choice has been selected.

[Tanner_2004]

I have a worksheet that has 8 activex listboxes. Each listbox is tied to the sames list of values (identified as a named range). The named range is a list of countries. Each country should only be selected once, therefore, I would like the selected country(ies) to not show up as a choice when the user makes a selection from another listbox. If this is too hard, maybe we can get a msgbx to appear anytime the users tries to select a country that has already been selected.
All thoughts and help would be greatly appreciated.

Thank you very much!

 

[MickG]

Do you propose to select only one country from each ListBox or do you intend to have multi selection in each ListBox.

 

[Tanner_2004]

Super question: one per listbox. Sorry for leaving that out. Thank you for checking with me.

 

[Tanner_2004]

Here's another issue I didn't think about. I would like of the choices to be Select Country or at least the default response for each listbox. Therefore, two or more list boxes should be able to have that value selected without invoking an error message.