Extract data from listbox

[kod2th3e]

Is it possible to extract a value from the listbox? I have a listbox that populates automatically from a table on an excel sheet. It has 7 columns and the number of rows varies in length. I was wondering if I select a row from the listbox is it possible to extrapolate the value that resides in the first column of that row and assign it to a variable?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]apple
[/TD]
[TD]red
[/TD]
[TD]round
[/TD]
[TD]asdf
[/TD]
[TD]asdf
[/TD]
[TD]sdff
[/TD]
[TD]1234
[/TD]
[/TR]
[TR]
[TD]pear
[/TD]
[TD]green
[/TD]
[TD]round
[/TD]
[TD]asdf
[/TD]
[TD]zxcv
[/TD]
[TD]jhkl
[/TD]
[TD]6543
[/TD]
[/TR]
[TR]
[TD]banana
[/TD]
[TD]yellow
[/TD]
[TD]oblong[/TD]
[TD]qwerqw
[/TD]
[TD]wer
[/TD]
[TD]fgdsd
[/TD]
[TD]0987
[/TD]
[/TR]
[TR]
[TD]kiwi
[/TD]
[TD]green
[/TD]
[TD]oval
[/TD]
[TD]qwerx
[/TD]
[TD]jh;ol
[/TD]
[TD]nm,.
[/TD]
[TD]8394
[/TD]
[/TR]
[TR]
[TD]orange
[/TD]
[TD]orange
[/TD]
[TD]round
[/TD]
[TD]aswef
[/TD]
[TD]nm.
[/TD]
[TD]nm.
[/TD]
[TD]2048
[/TD]
[/TR]
</tbody>[/TABLE]

Say the above table represents my listbox, I'd like to select the row with "1234" and have "apple" be assigned to a variable. Thanks in advance for any/all help, you're time is much appreciated.

 

[kod2th3e]

I have continued to dig around and found something that works for what I'm attempting, it is as follows:

lbl9.Caption = ListBox1.List(ListBox1.ListIndex, 0)

I used a label to display the result. The 0 (zero) at the end indicates which column you want to pull the data from within the selected row. It is zero based so if I wanted to display "1234" in the label I'd put the number 6 instead. I hope that someone else may find this information useful.