You could try a macro like this and assign it to a button
on a toolbar:
Sub NewComment()
Dim commTxt As String
commTxt = InputBox("Enter comment text: ")
If commTxt = "" Then Exit Sub
With ActiveCell
.AddComment
.Comment.Text Text:=Format(Now(), "mm/dd/yy") & _
Chr(10) & commTxt
.Comment.Visible = False
End With
End Sub
---
HTH
Jason
Atlanta, GA
-----Original Message-----
My question is short and sweet. Is there any way to
have the current date
automatically appear when inserting a comment.
Obviously Excel puts the
current user....I'd like to get rid of that and have the
date instead. Any
assistance you could give would be greatly appreciated.
Thanks
Eric
.
|