Add timestamp to comment upon comment creation (Excel 2007)

Is there anyway to timestamp a comment after the user inputs it?

For example he right clicks on a cell and chooses insert comment. Types in whatever.. and clicks somewhere else effectively saving the comment. Strange behavior that. You would think they could hit enter or something to leave the comment input box. This is probably the real issue. There is no trappable event here to break into code so I can add a timestamp to the comment.

Also, if name is appended automatically perhaps there is a setting to append timestamps automatically. I'll look for this.

Thanks,

Julian

Try this , it should add the current date (In Red) to the end of the Text in the selected cell comment, and also update any existing date.

Please Login or Register  to view this content.

Regards Mick