ListBox Click event not working

[dinamike1]

I currently have a set of ListBox controls on a worksheet tab. They are all configured as multi-select and i have the values populated via the ListFillRange properties. Each listbox has an '{All}' option; when the user clicks on this value I want to de-select all other previously selected values. The code for this is straightforward enough, but I cannot get it to fire using the _Click event. Does anyone know why this is not working?

Additionally, I attempted to use the _Change event but quickly got caught in recursive loops which obviously is not going to cut it.

 

[Batbloke]

I know this is a very old thread, but I thought I may have a solution for anybody searching with regard to this issue.

I recently laid a listbox on a modal form, which I populated from its calling form before showing it. The listbox is set as multiselect and with the list style set as 'Option' (which
change to check boxes in multi-select).

My code was simply to check what was in the second column, if it contained a certain phrase (the calling code ensured any such listitem was pre-selected), then if the user tried
to deselect, it would simply reselect. Any items without the phrase could be selected on or off at will.

Fine, but the Click event didn't fire!

So here's my kludge - sorry, I mean fix.

1/ In the Form.Activate event I placed - Application.EnableEvents = True
(and no, that did not fix the click firing event, BUT:-

2/ I shifted my click event code into the Mouse Up event and it all worked great!

Note: In my case it had to be the Mouse Up event, not the Mouse Down event (both would now fire - but not the Click ??) - as ListIndex retains the previous setting during the Down
event (which kind of makes sense), it's only until the mouse button is released that the ListIndex is shifted to the NOW selected item.

Anyway, this may help somebody another nine years into the future (blimey, wonder if I'll still be around?)
Regards BB