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