Listbox Mouse Down Event

[jj554]

Good evening,

I am having trouble finding an event to trigger the mouse click in a listbox. I tried using the Mouse Down event however the event doesn't change selections before firing. I need the list index to change when the event is fired so that I can reference the list index of the item that I selected with the event. Currently when the event is fired, it references the list index of the item that was selected before the Mouse Down event. Does anyone have any ideas how I can use the Mouse Down event to reference the new item's list index that is selected with the mouse click?

I have a sample workbook that demonstrates what I am referring to.

Thanks for the help!


This is the sample code I use in the workbook:

Please Login or Register  to view this content.

[humdingaling]

change it to listbox1_change instead of mousedown

or mouseup works too

[ExcelHelper2]

One more option would be to change the first line to use click event.
Private Sub ListBox1_Click()