Excel drop down list multiple selection without duplicates. VBA code included

Excel 2013 Data validation drop-down list multiple entries without duplicates. Does not allow to reselect already selected item from dropdown. Very simple. Make sure macros are enabeled

Code for VBA is under link:

Õpetus kuidas teha exceli rippmenüüs mitu valikut. Sama asja ei saa mitu korda valida.

[fll]

Thank you ! Works perfectly, just need to be clear : the number for the column need to be adjusted to the number of your own column (8 in my case) were the droplist is.

[aprilby]

Thank you! If I have several drop-down lists with multiple selection within the same sheet, what should i do? Much appreciated if you could help me with it

[steeleher]

If you have multiple columns that you need to have multiple options selectable in the drop down list how do you edit the VBA code to work in multiple columns instead of just working in one target column?

[MyWTFName]

Unable to de-select or change an entry after the first selection.