Userform listbox - change event

[Formula11]

How can a change event be captured in a list box, when you re-select the same item.

In this case, there are 2 list boxes.
1. After selecting an item in the first listbox, there is a change event. OK.
2. Then select an item in the second listbox, there is a change event. OK.
3. If I go back to the first, select the same item, there is no change event.

How can 3. be solved?

Private Sub ListBox1_Change()
    MsgBox "changed 1"
End Sub

Private Sub ListBox2_Change()
    MsgBox "changed 2"
End Sub

 

[Micron]

Use click event instead (or also)? If you re-select the same selected item, there is no change.

 

[Formula11]

Thanks, but the click event didn't work.
I'll look into it further.

 

[mikerickson]

Both the Change and the Click event of a Listbox requrie a new item to be selected. One workaround that will react to an item being selected again would be to use the MouseUP event.

 

[Formula11]

Thanks this actually worked.
Helps a lot.