Bob's suggestion is giving me a formula that puts =TODAY() in the
active cell. This won't work. the TODAY function is giving me the
"current" date _not_ "today's" date

..If I come back tomorrow, the cell with the TODAY formula in will
reflect the current date instead of the date that I entered it.

You see what i mean when I say that I need a macro that will put
today's date in the active cell, not the "current" date?

again, i'm keeping records, so it's no use to use TODAY if the date
constantly changes.


---
Message posted from http://www.ExcelForum.com/

Hi
if you put Bob's suggestion into a macro (e.g. Commandbutton or using
the worksheet_change event) the value won't change. Find below the
example code for a command button who will insert the date into the
active cell
Private Sub CommandButton1_Click()
ActiveCell.Value = Now
End Sub

Frank