Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default datestamp a comment into a cell

Is it possible to have the date in which a comment is editted populate into
an actual cell?
  #2   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Datestamp & Paste Chart resolution SteveG[_2_] Charts and Charting in Excel 2 October 28th 07 01:20 AM
copy comment content to cell content as data not as comment Lilach Excel Discussion (Misc queries) 2 June 21st 07 12:28 PM
Datestamp Pieman Excel Worksheet Functions 4 March 11th 06 12:31 PM
Filling a cell with today's date (Datestamp completed marco) Diane Alsing Excel Programming 7 February 14th 05 10:54 AM
change datestamp from yyyy-mm-dd to yymmdd jst_se Excel Programming 3 July 22nd 04 06:30 PM


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"