Fill a listbox with an array in vba

Question

Does anybody know how can i fill a listbox from an array? I only know the method with:

With Tabelle1.ListBox1
    .AddItem "Versuch"
End With

i want to make a dynamic listbox but still have no idea.

Just use the Listbox's List property, e.g., Tabelle1.ListBox1.List = myArray. — Doug Glancy
– Doug Glancy, Commented Jul 4, 2015 at 19:32

tbur · Accepted Answer · 2015-07-04 19:45:45Z

4

Sub Listbox_Things()

'My Listbox is called "Listbox1" and it is located on "Sheet1"
'With the Listbox visible, F8 through this code

    With Sheet1.ListBox1
        .List = Split("1,2,3", ",")
        .Clear
        .List = Array("One", "Two", "Three")
        .Clear
        .List = Array(1, 2, 3)
        .Clear

        Dim x() As Variant
        x = Array("One", "Two", "Three")

        .List = x
        .Clear
        .List = Application.GetCustomListContents(4)

    End With
End Sub

answered Jul 4, 2015 at 19:45

tbur

2,4941 gold badge16 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ManInTheMiddle Over a year ago

thank you very much! is it possible to see what ive selected in a multiselection? Ive choosen the array way because i think it is better to recognize which items are selected by a user with array-indexing

Collectives™ on Stack Overflow

Fill a listbox with an array in vba

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related