Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home



Update date and time in Excel Document

Posted by Vu Dinh on September 28, 2001 12:25 PM
How to set up function for update the dates, times in Excel document? Every time when I make any changes in this document, I want to know automatically the date and time when I make that change.
thanks,
Vu Dinh

Re: Update date and time in Excel Document

Posted by Greg Collett on September 28, 2001 1:23 PM


Vu

Try to use the =Now() function. It records the date and time that the workbook is opened or calculated.

It can be incorporated into a macro but you have to be careful that it does not become unstable if you use a cell change macro.


Hope this helps

Cheers


Greg




This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.