Combo Box Unique Entries

  • Thread starter Thread starter rk0909
  • Start date Start date
R

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
 
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.
 
Back
Top