Excel Adding Date

J

Jason Southco

I have a form that uses an if statement to see if a cell is blank. If not, it
adds the date using TODAY. The problem is the date changes when the system
date changes. Is there a way to insert the date, but have it stay fixed when
the system date changes?
 
R

Ryan Jones

if you do a worksheet(1).Range(a1).value2 = Today() then is should remain
assuming you never have the if statement true. Which it shouldn't being you
will have data in the Cell....

This is one way
 
Top