Thread: Now function
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Now function

Learn something new everyday, and I doubled checked just to see if that
was in Excel 2002 as well as Excel 2007 and it was.
Thanks for pointing that out, that use of F9 is certainly not intuitive
but I doubt that it would cause accidental problems.


It was a new one for me too! Remember, this is Teethless mama's discovery,
although he doesn't mention how long ago it was that he discovered it.

Incidentally, often such entries can be automated to create
the timestamp when the adjacent cell is updated, so much
less work using an Change Event macro if that sheet gets
a lot of new entries. The user would have to change the code
but something along the lines of
http://www.mvps.org/dmcritchie/excel...#datetimestamp


True, but as Harlan has pointed out to me a couple of times in the past,
macro solutions are not always desirable.

Rick