Share via

Adding Dates to Comments

Anonymous
2010-10-04T18:50:34+00:00

Is there a way to set Excel comments so that when you add a comment, it not only shows who added, but the date that it was added?  I know that it can be typed in manually, but would be nice if it could be set up to be automatic.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-10-04T20:04:49+00:00

Hi,

there is no automatic way to set the date the comment was added. You must set the whole comment by VBA:

example:

Sub SetComment()

  With ActiveCell

    .AddComment "Your name:" & Chr(10) & Format(Date, "dd/mm/yyyy")

  End With

End Sub

Regards,

Frank

If this post is the answer to your question, please mark it for all readers as the Answer and helpful!

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-10-04T20:36:58+00:00

    Thank you Frank!!!

    Was this answer helpful?

    0 comments