Checkbox won't uncheck

Hi,

you can try this :

dim ctrl as control

for each ctrl in activesheet.controls

ctrl.value = false

next

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?

private sub checkbox3_click()
If CheckBox4.Value = True Then
        CheckBox3.Value = False
Else:
     If CheckBox3.Value = True Then
        MsgBox ("")
        CheckBox3.Value = False
     Else:
        CheckBox3.Value = True
     End If
End If
end sub

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

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!

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