Excel Refer to Multiple List Box Selections 1

[TheBlade]

Hi

I have a List Box control on my worksheet with 'Multi' selection type, and I would like VB code to return the values selected.

Please note that the control is on the worksheet, not in a user form (I've searched for a solution but the only ones I've seen refer to list boxes on user forms).

Any advice would be greatly appreciated.

Thanks!
Vince

 

[SkipVought]

Vince,

You have to loop thru each item in the listbox and test for the Selected property

Skip,
[sub]
[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it![/sub]

 

[TheBlade]

Thanks Skip, unfortunately I am not a VB expert. Can you plse give me a quick example? Perhaps one that takes the results and puts them in adjacent cells?
Thanks
Vince

 

[SkipVought]

Is this a FORM control or Control Toolbox control?

Skip,
[sub]
[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it![/sub]

 

[SkipVought]

This is a solution for a FORMS listbox

    c = 1
    With ActiveSheet.Shapes(1).OLEFormat.Object
        For n = 1 To .ListCount
            If .Selected(n) Then
               ActiveSheet.Shapes(1).TopLeftCell.Offset(0, c).Value = .List(n)
               c = c + 1
            End If
        Next
    End With

Skip,
[sub]
[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it![/sub]

 

[TheBlade]

Great I can work with that, excellent thanks alot Skip!!