your amendment did allow me to uncheck both boxes, however it disabled the ability of one box to switch the other box's condition.
[QUOTE=xladept]Maybe:
Please Login or Register to view this content.
[QUOTE=analystspec4]XLA,
Hi, in april of 2013 your resolved a challenge a for a member: the issue was clicking on one checkbox and therefore unchecking another checkbox. you resolved the issue. Here is the code you provided in the previous post:
Private Sub CheckBox1_Click()
Range("R223") = CheckBox1.Value
CheckBox2 = Not CheckBox1
End Sub
Private Sub CheckBox2_Click()
Range("R226") = CheckBox2.Value
CheckBox1 = Not CheckBox2
End Sub
This worked perfectly for me.
What I'm hoping you may resolve for me:
Can you modify the code so that when I uncheck the first box the second box isn't automatically changed to TRUE until the user checks the box.
currently:
A. Beginning with both boxes unchecked
1. check box 1 --> check box 2 remains FALSE (this is agreeable)
2. check box 2 --> check box 1 switches to FALSE
3. uncheck box 2 --> check box 1 switches to TRUE
I cannot have both boxes remain FALSE currently. The reason I need this condition is that the checkboxes are making particular data visible I would like the ability to have both boxes to remain at FALSE so all data can be "hidden" (by conditional formatting) until one or the other boxes is checked.
Bookmarks