UF Listbox Exit Event

[mikeymay]

It is possible to detect when a listbox with an item selected, is exited, i.e. another control in the userform gets focus?

If an item in the listbox is selected, I need to unselect it when the listbox loses focus.

As I have quite a lot of controls on the form I don't want to have to put code in for control getting access to unselect any items in the listbox and ideally I just need the one event procedure for exitin g the listbox.


TIA

 

[DanteAmor]

Try this:

Private Sub ListBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
  Dim i As Long
  For i = 0 To ListBox1.ListCount - 1
    ListBox1.Selected(i) = False
  Next
End Sub