Hey Joe,

This worked for me when I used the forms menu to create my check box. I
linked my checkbox to F4, and I placed the time in F5.

Sub CheckBox1_Click()

With ActiveSheet
If [F4].Value = True Then
With [F5]
.Value = Now
.NumberFormat = "mm/dd/yyyy h:mm:ss AM/PM"
End With
Else
With [F5]
.Value = Null
End With
End If

End With

End Sub

Hope this helps!

Stephanie

"Joe" wrote:

I am pretty new to macros and just found out what they were and kind of how
they work. I am trying to make a check list that when the box is checked the
current time is inserted to a different cell. Any advice on how to do this
would be much appreciated.

Thanks,
--
Joe