Filling listbox with multiple columns question. 1

[IndigoDragon]

Hi everyone,

Farely basic question I guess, but how do I add items to a listbox with multiple columns? I mean, how do I add values to the different columns of one index item?
I can't get the syntax right doing it with .AddItem and .Column() is a read-only property (right?).

ThanX for your replies.

 

[ck1999]

Try this code

ListBox1.AddItem "helpme"
ListBox1.Column(1, ListBox1.ListCount - 1) = ("adios")

This works for me.
Chris

 

[FaneDuru]

It works only if ColumnsCount is set to the maximum number of columns (in Properties or in code):

Private Sub UserForm_Activate()
 ListBox1.ColumnCount = 3
 ListBox1.AddItem "helpme"
    ListBox1.Column(1, ListBox1.ListCount - 1) = ("adios")
    ListBox1.Column(2, ListBox1.ListCount - 1) = ("TEST")
End Sub

Fane Duru

 

[IndigoDragon]

Hi ck1999,

Thanks for that!
And how would I get the checked value in a selection-styl listbox?

Greetz!

 

[IndigoDragon]

Got it!

myListbox.Selected(index)

thanx for your replies guys/girls!