Hi

I am trying to create a spreadsheet in Excel which will record the lap times
of a number of riders in a bike race. At the moment I have a button in
column A for each of the riders, when the user clicks the button initally the
start time displays in Column B, I'm wondering if it's possible to create a
macro which would record the time at the end of lap one in column C on the
second click of the button, then the time at the end of lap two in column D
on the third click and so on.

Hope that makes sense!
Thanks
Mel

Sub bike1()
Cells(2, 256).End(xlToLeft).Offset(0, 1) = Format(Time, "hh:mm:ss")
End Sub


"MelNeedsHelp!" skrev:

Hi

I am trying to create a spreadsheet in Excel which will record the lap times
of a number of riders in a bike race. At the moment I have a button in
column A for each of the riders, when the user clicks the button initally the
start time displays in Column B, I'm wondering if it's possible to create a
macro which would record the time at the end of lap one in column C on the
second click of the button, then the time at the end of lap two in column D
on the third click and so on.

Hope that makes sense!
Thanks
Mel

Thank-you!

"excelent" wrote:

Sub bike1()
Cells(2, 256).End(xlToLeft).Offset(0, 1) = Format(Time, "hh:mm:ss")
End Sub


"MelNeedsHelp!" skrev:

Hi

I am trying to create a spreadsheet in Excel which will record the lap times
of a number of riders in a bike race. At the moment I have a button in
column A for each of the riders, when the user clicks the button initally the
start time displays in Column B, I'm wondering if it's possible to create a
macro which would record the time at the end of lap one in column C on the
second click of the button, then the time at the end of lap two in column D
on the third click and so on.

Hope that makes sense!
Thanks
Mel