Solved: Adding days when checkbox checked

[SallysPizza]

I'm sure this is something that has to be done in VBA. I have a check box that when clicked makes several more check boxes visible (Thanks xld!!) When this same checkbox is clicked, I need to add 3 days to the current date (which I use the formula =NOW() in cell J1) and then put the result in a different cell.

In other words if today is 11-04-08 and the checkbox is clicked, 14-04-08 shows up elsewhere on the sheet.

Makes sense?:think:

[MikeO]

ActiveCell = Now() + Day(3)

[mdmackillop]

Something like

Private Sub CheckBox1_Click()
If CheckBox1 = True Then
Range("E10") = Date + 3
Else
Range("E10") = "Date cleared"
End If
End Sub