Clicking on a row in a listbox

[conorohio]

Hi,
I'm using excel 2003 Windows XP, and I'm trying to trigger an event, when clicking in a list box, that is specific to the row I click on.

Although I know the list box can tell which row I click on since that row will highlight, I see no function or property that would allow me to return the number of the row that was clicked.

One way to do this would be to use the X and Y values returned by mousedown/mouseup to figure it out, however because my listbox has a scrollbar these values won't always determine the correct rows.

Does anyone know how to do this?

Thanks

 

[Lewiy]

The ListBox has a property called ListIndex which returns the current position in the list (this starts from 0 being the first item in the list). As an example, use the following code behind the ListBox:

Private Sub ListBox1_Click()
MsgBox ListBox1.ListIndex
End Sub

Now when you click one of the items in the ListBox, a box will appear telling you what the index number of the item in the list is.

Hope that helps!

 

[Norie]

Couldn't you use the listboxes ListIndex property?