check box to indicate "no work required"

[jeagly167]

I have an excel workbook with two worksheets, a coversheet with check boxes
an action items tab. I would like, if the box is checked on the coversheet
tab to display the "no work required" in cell F4 on action items tab.

Thanks!

 

[Mike]

Put this into the CoverSheet module
Private Sub CheckBox1_Change()
If CheckBox1.Value = True Then
Worksheets("ActionItems").Range("F4").Value = "NO"
Else
Worksheets("ActionItems").Range("F4").Value = ""
End If
End Sub