NOW() function

[Eric]

I have a an option button with a macro that sets the
current date and time with a NOW() function. Problem is, I
have several of these buttons and when one is activated
all the dates and times are updated.

How do I Freeze the dates?

I was think about writing an IF formula that checks to see
if the cell has data before writing the NOW() function,
but I don't know how to write a logical expression that
does nothing if the cell has data.

(IF B27 is empty, NOW(),do nothing-not even 0)How do you
express that?

Guess that's two questions. Please help.

 

[Gilles Desjardins]

Eric if you want a fix date Ctrl + ; Your date shall never change

 

[Biff]

Hi Eric,

Here's something you might try. In your macro right after
the call for the NOW function, add some code to do a
copy>paste special>values on the cell where the date/time
displays. Sorry I can't provide any code other than is
generated by the recorder.

As far as the IF function, it will always 'do something'.
Even if you were to write it as:

=IF(ISBLANK(B27),NOW()))

By default would return FALSE if B27 <> blank.

Biff

 

[Eric]

Thanks Biff. Just had another thought: suppose i would set
one of the actions as something benign like "set text to
black", like it is anyway. Can you think of any other ways
to get around the fascist "IF" logic?

 

[Biff]

As in setting a conditional format?

-----Original Message-----
Thanks Biff. Just had another thought: suppose i would set
one of the actions as something benign like "set text to
black", like it is anyway. Can you think of any other ways
to get around the fascist "IF" logic?
.