Date function within a Comment Box? (2003)

Topic

New Reply

When we select a cell to enter a ‘comment’, is it possible to incorporate a =NOW() function to calculate “today’s date” within that comment box in the active cell selected?

Reply | Quote

Replies

You can not add a function, the comment displays text

This line will put the current date into the comment of the activecell.

ActiveCell.AddComment _
Text:=”Today’s Date is ” & vbLf & _
Format(Date, “mmm d, yyyy”)

You can add it to a macro. Is this what you are after?

Steve

Reply | Quote

Thanks Steve for the info. This will do just fine.

Reply | Quote