Todays Date that does not update

T

Tom Meacham

I created a macro and a button that when clicked it entered todays date in a
cell, which is what I wanted. I used "Today( )".
Problem is the date keeps updating to todays date and I want it to stay the
date I entered it in. Is there some other value or formula to do this so it
does not update everyday?
Thanks!!
 
C

Chip Pearson

You need to enter the date itself. Any function will always
update to the current date. Ctrl+; will enter the current date in
a cell.

In VBA, use

Range("A1").Value = Date



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top