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

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

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

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


"bonobo" wrote:

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

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

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



--
Gary''s Student - gsnu200837


"bonobo" wrote:

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