Data Validation - Selecting multiple items with ability to deselect items

Hello,

I have the following VBA to create a data validation list where the user can select multiple items, which are separated by a comma. The setback is that an item cannot be deselected. I am wondering how the code could be modified so that it has the functionality to deselect a selected item.

Please Login or Register  to view this content.

Thank you,

Dan

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachements to open the upload window.

View Pic

I cannot paste code.

But you only need to change two lines.

But I found that you can simplify you code and remove most of your if then statements.

I wonder? Maybe we should use ", " as a delimiter in all cases.

But then we would need to make sure that you could not select the last entry.

Please Login or Register  to view this content.

This is easily fixed.

Please Login or Register  to view this content.