[RESOLVED] listBox how to get specific items

[chriskaza81]

well anybody know how can i get for example the second item from a listbox????????????

[ganeshmoorthy]

MsgBox List1.List(1))

[ganeshmoorthy]

syntax is
control.List(position)
position starts from 0 so, 2nd item means 1

[l12ngo]

msgbox Me.List1.List(1)

If you wanted to msgbox out the third item:

msgbox Me.List1.List(2)

Obviously this is assuming your list is called List1.

[d3gerald]

to get the second item from the listbox, do it like this

dim SecondVal As String
SecondVal = list1.list(1)

to get specific values in a listbox, use the list property and supply the index number of the data you want to retrieve

the index starts with 0 so if the listbox has 5 items, the index would range from 0 to 4

or 0 to list1.ListCount - 1
ListCount returns the total number of items in your listbox

[vbcode1980]

Do you mean

MsgBox ListBox1.List(1)

(The index starts at 0, so item 2 has index 1)

[vbcode1980]

Whoh, 5 similar posts in less than a minute

[chriskaza81]

thanks...................

[d3gerald]

then can you mark this thread as resolved. just see my signature <below the line after this message> for instructions on how to do it ok.