View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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?