+ Reply to Thread
Results 1 to 4 of 4

Excel Timer

  1. #1
    Registered User
    Join Date
    09-22-2010
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    46

    Excel Timer

    I would like some vba to start a timer in cell A1. Basically there would be three buttons, one to start, stop, and reset.

    Thanks
    Last edited by fride360; 06-05-2014 at 12:48 PM.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Auto refresh of time

    Hi fride360,

    Take a look at the code for Timer0 in the file (Sheet 'FrontSheet') for post #4 in:
    http://www.excelforum.com/excel-prog...wn-timers.html

    If you can't figure it out, let me know and I will extract that code into a separate file.

    Lewis

  3. #3
    Registered User
    Join Date
    09-22-2010
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    46

    Re: Excel Timer

    Thanks Lewis, I checked that out and it was way over my head. I think what I'm actually looking for is just simple timer that would operate by three buttons, one to start, stop, and reset. Thanks

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Excel Timer

    Hi again,

    Try the attached file which is much simpler and easier to understand.

    Lewis

    Code follows which will display the elapsed time in cell 'A1' on 'Sheet1'

    In the ThisWorkbook module:
    Please Login or Register  to view this content.

    In an ordinary code module:
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Enable Auto Refresh - Wait for refresh to sinish before running a macro
    By tomlancaster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2011, 11:52 AM
  2. Auto Refresh Time
    By klick_80 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2006, 04:00 PM
  3. Auto Refresh Time
    By klick_80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2006, 11:23 AM
  4. Auto Refresh Time
    By klick_80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2006, 11:21 AM
  5. [SOLVED] Auto-run macro after auto-query refresh (Excel2000,sr1)
    By Bill Cufflin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2006, 10:35 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