Selecting data in ListBox
 

I have a 2 column ListBox containing 10 rows of data.
When the user clicks a row,
I want to allocate the data in the first column to one variable
and the data in the second column to a second variable.
I can get the column 1 data using :-
Variable1=UserForm1.ListBox1.Text
but how do I get the column 2 data?
donwb