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.