is it possible to time stamp cell comments?

[Dave F]

Is there a way to do this?

Dave

 

[Paul B]

Dave, if Kevin answer is not what you need maybe this will help
http://www.contextures.com/xlcomments03.html#DateTime
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Kevin B]

Way cool tip there Paul B. and a good site to boot.

Thanks...

 

[Dave F]

Thanks, this is interesting. When I use this code and try to run the macro,
I get a pop-up window titled "Add Procedure" with a bunch of options to
select. What's that?

Dave

 

[Kevin B]

Dave, the code worked fine on my PC, it just inserts a comment with the date
and time already posted. This is the code I'm running:

Sub CommentDateTimeAdd()
'adds comment with date and time,
' positions cursor at end of comment text

Dim strDate As String
Dim cmt As Comment

strDate = "dd-mmm-yy hh:mm:ss"
Set cmt = ActiveCell.Comment

If cmt Is Nothing Then
Set cmt = ActiveCell.AddComment
cmt.Text Text:=Format(Now, strDate) & Chr(10)
Else
cmt.Text Text:=cmt.Text & Chr(10) _
& Format(Now, strDate) & Chr(10)
End If

With cmt.Shape.TextFrame
.Characters.Font.Bold = False
End With

SendKeys "%ie~"
End Sub