View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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

.