I’ve posted a few techniques for selecting multiple items from the drop down list in a cell. In the screen shot below, there is a drop down list in cell C3. When you select an item from the list, it’s added to the cell, instead of overwriting the previously selected value. Now, instead of a cell drop down, here’s how to select cell items from ListBox.
This screen shot shows a cell drop down that is set up for multiple selections.
My new method combines that multiple selection technique with the combobox popup technique from one of my other data validation examples.
In this combo popup screen shot, there is a combo box over cell B3, with a list of Weekdays. There is only one hidden combo box on the worksheet, and it appears when you click on any cell that has a data validation list.
Show a Listbox
In my new method, when you click on a cell that has a data validation list, a listbox appears. It shows all the items from the source list, with check boxes, so you can select multiple items.
The listbox is embedded in a UserForm, which also has OK and Cancel buttons.
When you click OK, all the selected items are added to the cell, separated by a comma and space.
Listbox Instead of Combo box
I used the listbox, instead of a combo box, because the listbox makes it easier to select several items, by adding check marks. You can see several options at a glance, and scroll down, if the list is long.
In the next screen shot, there are 1100 entries in the ItemList, and you can quickly scroll through them all in the Listbox.
Download the Sample File
To see the code, and experiment with the Listbox, you can download the sample file from my Contextures website.
The zipped file is in xlsm format, so enable macros when you open the file.