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

preview_player
Показать описание
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.
Рекомендации по теме
Комментарии
Автор

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.

fll
Автор

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

aprilby
Автор

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?

steeleher
Автор

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

MyWTFName
join shbcf.ru