+ Reply to Thread
Results 1 to 3 of 3

Stopwatch: Help Me Modify VBA

Hybrid View

  1. #1
    Registered User
    Join Date
    03-29-2014
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Stopwatch: Help Me Modify VBA

    Hi everyone,

    I wanted to create simple stopwatch and found this on Youtube.
    I followed the instruction and came up with something like this (see attachment)
    But actually, this is not exactly what I want.

    Could anyone here help me modify VBA, module or something?

    These are what I imagine:

    1. I only have ONE button only. (Start/Stop)
    2. I select ANY cell I want.
    3. I press the button.
    4. Stopwatch start in cell I select (point 2 above)
    5. Stopwatch run in format "sss.000" (second and in fractions. Not in minute. example result: 72.88 sec. (NOT--> 1:12.88 )
    6. I press the button again.
    7. Stopwatch stop.
    8. I select another cell.
    9. loop again from point 3.

    I hope I explained what I need well.

    And I hope some one will help me. )

    Thank you in advance.

    Mikairu.

    test stopwatch 3.xlsm

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Stopwatch: Help Me Modify VBA


    Point 5 - not with this method. Application.OnTime will not work fine with second fractions.
    As a matter of fact, I'd say excel is not best suited environment for such tasks.
    The rest (but point 5) can be reasonably easily done, but does it make sense if you cannot achieve such critical part?

    But to give you some hope - have a look on Zack Barresse code http://www.vbaexpress.com/kb/getarticle.php?kb_id=242
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    03-29-2014
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Stopwatch: Help Me Modify VBA

    Thank you, Kaper.

    Actually, I have tested your recomended code.
    It suited me in some part.
    But, I have problem in double clicking.
    It is not accurate as I wanted to.

    Could you suggest how to apply it on a button?

    Thank you.

+ 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. Stopwatch
    By bittu2010 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-20-2012, 05:01 PM
  2. Stopwatch/timer
    By Huwbob in forum Excel General
    Replies: 8
    Last Post: 10-18-2011, 08:46 PM
  3. Excel Stopwatch
    By daddy_smo in forum Excel General
    Replies: 2
    Last Post: 07-26-2011, 02:22 PM
  4. Stopwatch
    By Metolius Dad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2009, 07:18 PM
  5. Excel StopWatch
    By roy.furman@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2006, 08:05 AM

Tags for this Thread

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