Combo Box Unique Entries

[rk0909]

All,

I have 5 active x combo boxes on a worksheet. All have the same
listfillrange property.

Is there a way that once an item is selected in one combo box that
particular item cannot be selected in the other combo boxes (or does not even
appear in the other combo boxes).

thanks much for your help.

RK

 

[Patrick Molloy]

i did answer a similar question a week or two ago and linked a demo
spreadsheet.

the idea was that the listfill range was a range named table and when an
item was selected, the code attached to the combobo (1) copied the item to a
cell immediately to the left of the combobox and (2) deleted the item from
the table.
-- though it was data validation rather than comboboxes, the logic is
similar.