Checkbox won't uncheck

[eureka18]

Hi guys,

I'm having a problem. I have a worksheet with a lot of checkboxes on them. I want to make a button which unchecks all checkboxes at once. For most of the checkboxes it works to use

Please Login or Register  to view this content.

however, I have a few activex checkboxes that have some conditions in a _click sub. like:

Please Login or Register  to view this content.

if I trie to uncheck the checkbox by using .value=false it does not work. What is going wrong? Does anyone have an idea how to solve this issue? FYI can't use non-active x checkbox in this case.

thanks in advance!

[xlbiznes]

Hi,

you can try this :

Please Login or Register  to view this content.

[eureka18]

I get an object does not support that property or method error on

Please Login or Register  to view this content.

[Norie]

The problem is that the Click event of the checkbox will be triggered when you set it to False.

What is this code mean to do anyway?

Please Login or Register  to view this content.

It's seems like you have some sort of toggling going on.

[eureka18]

It toggles 2 checkboxes that may not be checked at the same time. So when the first one is true than the second one cannot be clicked and vice versa. Any idea how I can solve this problem while keeping the toggling?

- edit: solved the issue. dimmed an variable that = 1 if i do a reset. on the checkbox_click event i added an if statement to only execute the code if the variable=0

Thanks for helping me understand where the issues lies!

[Norie]

Glad you got it solved, but I've got to ask - why no use 2 option buttons?