software

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
quot;Jason Southcoquot; gt; wrote in message
...
gt;I have a form that uses an if statement to see if a cell is blank. If not,
gt;it
gt; adds the date using TODAY. The problem is the date changes when the system
gt; date changes. Is there a way to insert the date, but have it stay fixed
gt; when
gt; the system date changes?

Would NOW( ) work?