MrExcel Publishing
Your One Stop for Excel Tips & Solutions

time stamp


Posted by Mike on June 29, 2000 4:58 PM

Is there a formula and/or function to place a time stamp in a cell that will not change? Also, VBA code would be acceptable. Any help will be appreciated.


Posted by mike on July 07, 0100 11:30 AM


Ryan,
Thanks for the help,
Mike

Posted by Ryan on June 29, 0100 5:45 PM

Mike,
If you enter a formula, it will change. You can use this VBA though:

ActiveCell.Value = Date <-- Will enter mm/dd/yy
ActiveCell.Value = Format(Now(),"hh:mm") <-- 09:10
ActiveCell.Value = Format(Now(),"mm/dd/yyyy")

Try these. If you need some more help, let me know.

Ryan