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

Thanks for the help,

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

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.