I have placed a command button on sheet1 when clicked I need it to insert
todays date i.e. = today() into cell J2

Thanks in advance, David D

I have placed a command button on sheet1 when clicked I need it
to insert todays date i.e. = today() into cell J2

Is it a Visual Basic CommandButton? If so, in Design Mode, use this Click
event code...

Private Sub CommandButton1_Click()
Range("J2").Value = Date
End Sub

Rick

Attach the button to the following macro

Sub myDate()
ActiveSheet.Cells(2,10).Value = Date
End Sub

(10 being the column number corresponding to "J")

Hope that helps. -Lisa



On Jul 11, 1:59 pm, "David" wrote:
I have placed a command button on sheet1 when clicked I need it to insert
todays date i.e. = today() into cell J2

Thanks in advance, David D

attach the