I've created a few columns that allows for multiple selection in a data validation column. 2 issues that I'm trying to solve for. 1) I do not want user to be able to select the same item twice by accident and 2) allow user to delete a single item after a multiple selection has been made. Currently user receives error message when trying to delete an item from what they selected, stating 'This value doesn't match the data validation restrictions defined for this cell. ' The only way for person to edit their selection is to delete it entirely and reselect items from list, which is not ideal when several items could be selected.
I've attached a sample file with the VBA code I'm using that allows for multi-select. Can anything be added to resolve either of these issues above?
I've attached a sample file with the VBA code I'm using that allows for multi-select. Can anything be added to resolve either of these issues above?