Listbox with mult-selection capability

**ptborders** · 02-11-2012, 11:23 AM

Hey...I've made listboxes in the past where the single selection feature works in that the cell reference changes numbers based on the single selection of the list box. However, I would like to "upgrade" my listbox now so that multiple items in the listbox can be selected at once and there is a cell reference that changes numbers for each item in the list box.

I'm not versed on visual basic at all, so the simplest explanation you could offer would be much appreciated.
Thanks for your help in advance.
listbox.xlsx

**shakey775** · 02-11-2012, 11:39 AM

Hi
In the propertities set the "multiselect" property to 1 - fmmultiselectMulti

**royUK** · 02-11-2012, 11:55 AM

What do you want to do with the selected items?

**shakey775** · 02-11-2012, 12:03 PM

I thought you were using a listbox in a userform

in the worksheet select the listbox and then click properties button on the developer ribbon
when that opens in the control tab select the multi option button

james

**ptborders** · 02-16-2012, 06:24 PM

thanks...I attempted this solution but was not able to obtain cell references for each item in the listbox. The steps I take are as follows:

1. Developer tab, then insert a list box form control
2. Select the listbox, then click properties
3. Chose the multi option and then a corresponding range and cell link

The issue is that the cell link only refers to one cell...i'd like each item in the listbox to have a cell link when multiple items are selected...

**mikerickson** · 02-16-2012, 06:55 PM

A multi-select listbox from the Forms menu has to be driven by code rather than a cell link. Try assigning the control to a macro like

Sub ListBox1_Change()
    Dim i As Long
    With ActiveSheet.Shapes(1).OLEFormat.Object
        For i = 1 To .ListCount
            Cells(i, 2) = .Selected(i)
        Next i
    End With
End Sub

**ptborders** · 02-17-2012, 10:56 AM

Thanks Mike... this code worked well! As a slight modification, how would you choose which cells for the TRUE/FALSE values to populate in? Right now, B1seems to be the cell where the cell links show up.