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?
|