Excel Drop Down Multiple Select or Remove
84.9 هزار بار بازدید -
13 سال پیش
-
With Excel data validation you
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...
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...
13 سال پیش
در تاریخ 1390/06/13 منتشر شده
است.
84,929
بـار بازدید شده