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.

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


--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"MCrum" wrote in message
...
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.