Macro help- Push button that tracks what time it is pushed

[kd19504]

Hi all, I have a very basic background in macros but I am attempting to create a macro that when the button is pushed, a spreadsheet will track what time it was pushed at. Does anyone have suggestions? At this point I have just tried recording the macro by doing that, but on the spreadsheet I'm tracking it on, it won't move to the next cell to track the next time.

Any help is appreciated!

 

[CharlesChuckieCharles]

I take it you want a list of times for every time the Button is Clicked?


This records the button click times on column Z on sheet1 edit as required

Private Sub CommandButton1_Click()
Dim recordDepth As Long
recordDepth = Sheets("Sheet1").Cells(Rows.Count, "Z").End(xlUp).Row + 1
Cells(recordDepth, "Z").Value = Format(Now(), "HH:NN:SS")
'...... your code here
End Sub