Checkbox Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top