Checkbox Question

[MCrum]

I would like to have a "Yes" checkbox say in cell (or by) C1 and a "No"
checkbox in C2. If Yes checkbox clicked turns cell yellow and adds checkmark.
If No checked turns off yes and turns white and turn No Yellow. Hope this
makes since.

 

[John Bundy]

Use the tool box to add the checkboxes where you want then paste this in VBA
Private Sub CheckBox1_Click()
Cells(1, 1) = "YES"
Cells(1, 1).Interior.ColorIndex = 6
CheckBox2.Value = False
End Sub

Private Sub CheckBox2_Click()
Cells(1, 1) = "NO"
Cells(1, 1).Interior.ColorIndex = 2
CheckBox1.Value = False
End Sub