• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multi-select data validation

Wmickle

New Member
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?
 

Attachments

  • Chandoo question.xlsm
    16.8 KB · Views: 5
Back
Top