Tim,

You select a row, not a column. You can get at all values in the row like
so

MsgBox "Column 1: " & ListBox1.Value

MsgBox "Column 2: " & ListBox1.List(ListBox1.ListIndex, 1)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tim Coddington" wrote in message
...
Ok. So I have this multi-column listbox.
I've figured out how to tell which row is clicked.

Private Sub ListBox1_Click()
MsgBox ListBox1.ListIndex
End Sub

Is there a way to tell which column is clicked?

Thanks,
Tim