comment box with date

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

Is there a way to have a comment automatically open with
the days date next to the user name?
 
You could use a simple macro like this and add it to a
button on a toolbar:

Sub InsertComment()
With ActiveCell
.AddComment
.Comment.Text Text:="name" & Chr(10) & _
Format(Now, "mm/dd/yy") & Chr(10)
.Comment.Visible = True
End With
End Sub

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import Comments 3
How do I change the comment default format to include date? 4
User name , date and time 2
comments 2
automatic date entry in XL cell.. 3
comment with date 3
Word to Excel: Export comments with text and line number 0
Identifying who made a comment in 2007 1

Back
Top