List Boxes

[matthew230]

Hi,

Can anybody give me some guidance on using list boxes with multiple selection.

For example if I want to extract the value from a combobox I use:

strVariable = userform1.combobox1.value

or something similar.

How can I use list boxes in a similar manner ?

Many thanks

Matt

 

[mikerickson]

With ListBox1
    For i = 1 to .ListCount -1
        If .Selected(i) Then MsgBox .List(i) & " is one of the selected items."
    Next i
End With

 

[matthew230]

Thanks Mike, I'll do some experimenting....

 

[matthew230]

With ListBox1
    For i = 1 to .ListCount -1
        If .Selected(i) Then MsgBox .List(i) & " is one of the selected items."
    Next i
End With

Hi,

I've had a lilttle play this.

I had to alter i = 0 for it to pick up all selections. I guess that the first line is denoted as zero rather than one

 

[mikerickson]

My error. .Selected is a zero based array.