how do I put a date/time stamp in comments?

[bonobo]

how do I set up comments in Excel that automatically insert date/time stamp
as they are created?

 

[Sheeloo]

See Debra Dalgleish's solution at
http://www.contextures.com/xlcomments03.html#DateTime

 

[Gary''s Student]

Try this small macro:

Sub commenter()
Dim s As String
s = Now
With ActiveCell
.AddComment
.Comment.Visible = False
.Comment.Text Text:=s
.Select
End With
End Sub