View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Get current time NOW() but stop it updating

You can do that via a VBA event macro, but first you have to specify
1. in what cell do you want to enter NOW
2. what is the event (e.g. filling in a particular cell) triggering time
stamping.

Regards,
Stefi

€˛goneil€¯ ezt Ć*rta:

I want to time stamp a cell automatically with the current time (ie) without
the data entry operator having to do anything, however I don't want it to
update all the time I want it to just remain as is permenantly. I cannot
make NOW() stay the same.
Cheers