Selecting value from listbox

[Matthys]

Hi,

I have a two column listbox, list1.
How do I save the data on the 2nd column of the selected row?

To save data from the 1st column I do:

myData = list1.itemData(list1.listIndex)

Now for the 2nd column???

Why are lists so complicated?

 

[RuralGuy]

Use the Column property. It is a zero based index so the 2nd column would be: myData1 = list1.Column(1)

 

[Matthys]

Getting the index

Ok, thanx that worked.

Now say I have the value of a certain column in a certain row, how do i find the index of that row? Assuming that all rows are unique.

Sorry I'm dumbfounded by lists.

 

[RuralGuy]

Have you looked at the VBA help on Column yet? It has 2 parameters: Column(ColumnIndex, RowIndex). Maybe a little tutorial on ListBoxes would help.
Making Sense of List Boxes