Inserting current date
Thanks Mike,
One other issue. I receive the following error message when I protect the
form - Run time error '1004' Unable to set the text property of the
characters class.
"Mike H" wrote:
Hi,
the date won't change.
Mike
"pdaws" wrote:
Thank you Mike. I tried the code and it worked. One other question, will
the date remain constant and not change when the form is opened tomorrow?
"Mike H" wrote:
Hi,
If b25 updates with a macro then the same code should be used to populate
d25 like this
Range("B25").Value = "Somevalue"
Range("D25").Value = Date
Mike
"pdaws" wrote:
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.
|