Excel Drop Down Multiple Select or Remove
With Excel data validation you can create drop down lists on a worksheet. In this example, you can select multiple items from the drop down list, and the new items are automatically added to the existing selections in the cell.
If an item has been selected before, in the current cell, that item will be removed, if you select it again.
This video shows how the multiple select and remove features works. You can also see the Excel VBA code, and the steps that it goes through, when you make a selection in the drop down list.
You can download the sample Excel file for this technique, at the link below. The code for this example is on the sheet named "SameCellAddRemove"
https://www.contextures.com/excel-dat...
Watch video Excel Drop Down Multiple Select or Remove online without registration, duration hours minute second in high quality. This video was added by user Contextures Inc. 04 September 2011, don't forget to share it with your friends and acquaintances, it has been viewed on our site 86,41 once and liked it 13 people.