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
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