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?

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
"Jason Southco" wrote in message
...
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?

Would NOW( ) work?