+ Reply to Thread
Results 1 to 8 of 8

Excel Stopwatch to record bike laps

  1. #1
    Registered User
    Join Date
    10-07-2008
    Location
    Australia
    Posts
    4

    Excel Stopwatch to record bike laps

    Hi all, I hope someone can help please.

    What I'm after is similar to the attached file I've put up (which has been floating around on the net for a while), but instead of having the 'record' button to do the work, i'd like to be able to type the bike's number that's about to cross the lap line in cell A4 and then, as he does so, hit the enter button to record the data (just as the 'record' button currently does).
    It's only possible for one rider to cross the line at a time so that's not an issue.

    Then what i'd like is for the cell focus to move down to A5, ready for the next bike's number to be quickly typed in and entered, and so on, and so on.

    In other words at the end of the race I'll have a list of bike rider's numbers (same riders more than once) down column A in the order they crossed the line.
    Down the timer columns ("e,f,g,h & i") it will have the times with reference to the original starting time (Just as it already does)

    I could then take the rider's number from column A and deduct each recorded time from his previous to display his time for each 'Lap'

    Hopefully this makes sense and is achievable.

    And hopefully someone can be of help
    Thanks all.
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Replace the record codse with this

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    10-07-2008
    Location
    Australia
    Posts
    4
    Quote Originally Posted by royUK View Post
    Replace the record codse with this

    Please Login or Register  to view this content.
    Thanks for the code RoyUK,

    Unfortunately that doesn't appear to have worked.
    Now after starting the stopwatch, if I try to type a number into cell A4, it stops the stopwatch and that's all it appears to do.

    Thank you all the same

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I posted the wrong code, the original workbook also stops the timer when you enter the bike number. Once you enter a value manually you will stop the timer. This is because the code uses DoEvents,which is used to force the application to yield it's use of the processor for one cycle (usually 50ms), it's commonly used to allow other events in your application to fire while you're performing a resource intensive operation. If you don't use DoEvents you can't access the sheet nor use the other buttons.

    This code will add the times. If you want to use this workbook then I think you will need to note the bike numbers down and use the button to record the times. Add the bike numbers after the timer is stopped.

    Please Login or Register  to view this content.
    Last edited by royUK; 10-08-2008 at 09:09 AM.

  5. #5
    Registered User
    Join Date
    10-07-2008
    Location
    Australia
    Posts
    4

    Smile

    Quote Originally Posted by royUK View Post
    This code will add the times. If you want to use this workbook then I think you will need to note the bike numbers down and use the button to record the times. Add the bike numbers after the timer is stopped.

    Oh,, that's a bummer! It sort of defeats the whole purpose of why I wanted to do it to begin with then.
    The idea was to then have all the data there and tweak it to show particular lap times etc, and be able to produce a printable report, without having to do anything else manually.

    So are you saying it's not possible to do what I was hoping to do?

    Thank you for the help you've given by the way.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I don't think that you can do that with the current workbook. If I can think of anything else I will let you know.

  7. #7
    Registered User
    Join Date
    10-07-2008
    Location
    Australia
    Posts
    4
    Anyone else have any ideas on this?

    Thanks Roy for the help you've provided.

  8. #8
    Registered User
    Join Date
    04-27-2009
    Location
    Moscow
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel Stopwatch to record bike laps

    Quote Originally Posted by newbie08 View Post
    Anyone else have any ideas on this?
    It's not an Excel stopwatch but seamlessly integrates to. http://xnotestopwatch.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Delete record in access database with excel VBA
    By Eureka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2013, 02:15 PM
  2. Suggestions for Excel / Access interaction?
    By Malvaro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2008, 07:30 PM
  3. Search for duplicate record in 2 excel spread sheet
    By Jimi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2007, 10:12 PM
  4. Excel 2003 Not Excelling in Handling 2000 .xls File
    By pands in forum Excel General
    Replies: 4
    Last Post: 02-27-2007, 05:56 PM
  5. how to merge data from one excel into another excel
    By refreshplease3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2006, 08:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1