Remove Name From Drop Down After Its's Selected

[justair07]

Hello,

I'm using VBA to allow me to select multiple items from a data validation drop down list. What I would like to do is remove items from my list if something is already selected. I know how to do this from a regular drop down but the multi select makes this impossible for me to figure out on my own.

Here is the method I'm using for my list: https://www.youtube.com/watch?v=zuBT2RbflAI

A multiple selection looks like this in the cell: Justin, Brian, Chris

There is a comma and a blank space between the selections. So basically if i selected these three names they are no longer available for further selection. Then once the cell is cleared out, the names can be selected again (added back to the list).

Sorry I don't have permissions to post a sample or this would be a lot easier to see.

I'm aware this will require VBA and was hoping someone could help me out.

Thank you,

- Justin

 

[justair07]

I'm also using this method to refresh my data range as items from my list are removed: https://www.youtube.com/watch?v=6PcF04bTSOM at 3:20 mins into the video

It works great, I just need help with the VBA to remove the items in the list as they are selected and then replace them back to the list as they are no longer selected or being used.

Thanks again