check box to indicate "no work required"
 

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!

check box to indicate "no work required"
 

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

"jeagly167" wrote:

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!