ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   datestamp a comment into a cell (https://www.excelbanter.com/excel-programming/365335-datestamp-comment-into-cell.html)

excelwannabe

datestamp a comment into a cell
 
Is it possible to have the date in which a comment is editted populate into
an actual cell?

Norman Jones

datestamp a comment into a cell
 
Hi ExcelWannabe,

Is it possible to have the date in which a comment is editted populate
into
an actual cell?


Editing a comment does not fire an event, so it would not be possoble to
enter a date in direct response to such editing.

Perhaps, however, you could fire a macro, say on the activation of the
sheet, to copy some or all of the comments into cells on that sheet or,
possibly another sheet.


---
Regards,
Norman




All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com