ListBox_Click() Event

[mikeymay]

I am trying to implement a detection of a listbox item being clicked, either to select or unselect.

In previous projects I have used the _Click() event which has work exactly as I have needed it but this doesn't seem to work when implementing in this new project.

I have reviewed the project in which this was implemented and in that project the code executes as required, an item in the ListBox is clicked and the event fires.

From what I can see, it is suggested that the _Change event is used but this fires when the ListBox is being changed (either being populated with the RowSource and/or items being removed when I use a control to move the selected items to another ListBox) which I don't need to happen. I appreciate I can add some code to exit the event when it isn't needed but the _Click event worked perfectly well before......

Has there been a change in the VBE in the last 18 months to stop the _Click event working?


TIA

 

[mikeymay]

After a bit more digging it seems that is a ListBox's MultiSelect option is set to Multi, the _Click evet doesn't trigger.......how that makes sense I don't know.

Time for more unecessary code to be added......