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 so it cant be selected twice. 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 multi select list: https://www.youtube.com/watch?v=zuBT2RbflAI

The 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 I would no longer want those three names to be available. Then once the cell is cleared out, the names can be selected again (added back to the list).

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.

Sample attached

Thank you I'm sure this is not easy so any help is very much appreciated.

- Justin

Attached Files

Multiselect _Sample.zip (12.5 KB, 8 views)

Hum,

It seems that this poster found a solution. And did not inform us.
I was about to look at tis. But....

http://www.utteraccess.com/forum/ind...wtopic=2033500
https://social.msdn.microsoft.com/Fo...forum=exceldev
http://www.excelguru.ca/forums/showt...ed-Office-2013