Date formulas

[Lauralou]

Hi there

I'm (rather ambitiously) trying to set up a macro on a worksheet so that you press a button and excel will instantly put in a new row at the desired location and in addition to a few other things will insert today's date in a cell within that row. I was going to use the TODAY () function but my problem is that I don't know how I get it to keep that date when the sheet is opened on a later date and to stop it updating to whichever date. Its going to be an ongoing logsheet.

Can anyone help?

Cheers

Laura

 

[PA HS Teacher]

Did you want something like this?

Private Sub CommandButton1_Click()
Range("A5").EntireRow.Insert
Range("A5").Value = Format(Now(), "mm/dd/yyyy")
End Sub