http://www.mcgimpsey.com/excel/timestamp.html

--


Regards,


Peo Sjoblom

"pdaws" wrote in message
...
Hi,

When cell b25 is populated by a macro, I would like for cell d25 to
automatically enter the current date based on the population of cell b25.
I
would also like for that date to remain constant and not change when
someone
opens the form. Is it possible to create a macro to perform this function
or
is there a formula that I can put in cell d25?

Thanks for your help.