#1
|
|||
|
|||
Remove Name From Drop Down After Its's Selected, Office 2013
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 |
#2
|
|||
|
|||
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 Last edited by charlesdh; 12-12-2015 at 06:21 PM. Reason: Adde threads where cross post. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop down entries in table disappear when selected | rothbe | Word Tables | 1 | 06-05-2015 05:04 PM |
Using Drop Down Menu to present Selected data in same sheet | awaisdotcom | Excel Programming | 1 | 04-04-2015 12:40 PM |
Need macro to fill data from different sheets based on selected item from drop down | skorasika | Excel Programming | 1 | 03-13-2015 11:25 AM |
Returning a specific value when item is selected from a drop-down list | J Press | Excel | 4 | 09-10-2012 06:12 AM |
Out Of Office Rule Not Selected | DrDOS | Outlook | 0 | 11-27-2011 02:30 PM |