using pushbottons to put date and time in cells

[nathanv3223]

Hi again everyone I have been trying to modify 2 macros that I have. The ones that I have are not seeming to work. Can anyone help me please.

What I'm trying to do is use two push buttons a stop and start button. But I don't need it to add dates and time to further cells. I just need dates and times to b and c cells, b1 and c1. Then another set that would go to b2 and c2 and so on probably for about 20 rows does this make sense. I have attached a sheet showing what I am trying to do. can anyone help please.

[Simon Lloyd]

I think this is what you want, replace the code you have for your buttons with the following:

Private Sub CommandButton1_Click()
    Range("D" & Rows.Count).End(xlUp).Offset(1, 0).Value = "=NOW()"
End Sub

Private Sub start_Click()
     Range("C" & Rows.Count).End(xlUp).Offset(1, 0).Value = "=NOW()"
End Sub

now every time you click one of the buttons it will put the time and date in the next available cell in the column.