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.
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 a method to refresh my data range as items from my list are removed.
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
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.
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 a method to refresh my data range as items from my list are removed.
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