View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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