MrExcel Publishing
Your One Stop for Excel Tips & Solutions

fixed system date


Posted by Bill on June 21, 2001 10:56 AM

I need to find a way to grab the system date into a cell at the time an adjacent cell has a value entered. The problem with any of my attempts is that this date is volatile, and it needs to be a fixed - text would do OK.
I can do it manually with "Ctrl+;" at the cursor, but it needs to happen automatically.
Any ideas?


Posted by mseyf on June 21, 2001 2:00 PM

you could use the statement

DateValue(Now())

in your macro.

HTH
-Mark