I have two check boxes: CheckBox2 and CheckBox5. If CheckBox2 is clicked, then CheckBox5 should be disabled. When CheckBox5 is clicked CheckBox2 is disabled. I attempted this by using the following code:
The code however does not work as intended. For some reason, CheckBox5 remains disabled, even after I have unchecked CheckBox2. Any help would be appreciates. NOTE: No I can't switch to OptionButtons.
VBA Code:
Private Sub CheckBox2_Click()
If CheckBox2.Value = True Then
CheckBox5.Enabled = False
CheckBox5.Value = False
End If
End Sub
Private Sub CheckBox5_Click()
If CheckBox5.Value = True Then
CheckBox2.Enabled = False
CheckBox2.Value = False
End If
End Sub
The code however does not work as intended. For some reason, CheckBox5 remains disabled, even after I have unchecked CheckBox2. Any help would be appreciates. NOTE: No I can't switch to OptionButtons.