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.

multiselectlistbox01

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.

multiselectlistbox02

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.

multiselectlistbox03

When you click OK, all the selected items are added to the cell, separated by a comma and space.

multiselectlistbox04

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.

multiselectlistbox05

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.

__________________________

7 comments to Select Cell Items From ListBox

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>