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?

apple	red	round	asdf	asdf	sdff	1234
pear	green	round	asdf	zxcv	jhkl	6543
banana	yellow	oblong	qwerqw	wer	fgdsd	0987
kiwi	green	oval	qwerx	jh;ol	nm,.	8394
orange	orange	round	aswef	nm.	nm.	2048

<tbody>
</tbody>

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.