Select Cell Items From ListBox
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 I’ve created a new variation on this, combining it with the combobox popup technique from one of my other data validation examples. In the screen shot below, there is a combo box over cell B3, with a list of Weekdays. There is one hidden combo box on the worksheet, and it appears when you click on a cell that has a data validation list.
Show a Listbox
In my new example, 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 it’s much easier to select several items, by adding check marks. You can see several options at a glance, and scroll down, if the list is very 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.