CheckBox x ListBox - Loop Conflict

[Gatti]

Hello my friends... I got one issue with my Form's CheckBox and ListBox.

When I click on the CheckBox, it unmarks/marks every item in ListBox...

Works fine:

Please Login or Register  to view this content.

When I click on ListBox itens, if my click marks ALL itens, it marks the CheckBox

Please Login or Register  to view this content.

The problem is: When I try to put both codes together, they conflict

What happens:
* Cannot mark the Checkbox by clicking, because it activates the listbox event, and unmark the checkbox, because it runs the loop
* When I mark by clicking all itens in listbox, checkbox gets marked, but when, after, I unmark one item, the checkbox gets unmarked, making the code of checkbox unmark ALL listbox itens

[LJMetzger]

Hi Gatti,

This should help you turn your sad face into . What you need is a 'Disable Events' for your UserForm. Excel does not provide one, so you have to bring your own to the party.

Try something like the following code in your UserForm code module. I was unable to test the code, because I did not see a sample file.

Please Login or Register  to view this content.

I hope this helps.

Lewis

[Gatti]

Hello Lewis

Thanks in advance!

Just managed to fix my problem using the MouseUp event

I'll just keep the answer here... if someone has the same problem as I

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thread marked as [SOLVED] and added reputation cause your good solution!

Thanks again.

[LJMetzger]

Hi,

Thanks for the rep points. I come across situations like yours all the time and usually solve it with a Pseudo-UserForm-Event-Disable Software Flag like I posted above. I occasionally use other workarounds, but I never thought of using a Mouse Event. Excellent idea.

Lewis