+ Reply to Thread
Results 1 to 4 of 4

Excel VBA Timer

  1. #1
    Registered User
    Join Date
    03-07-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    182

    Excel VBA Timer

    Hi,

    I have this userform with 1 Command Button and 1 Textbox. If the the user click the CommandButton (with Start Caption) the time will show in TextBox 1 with running timer this format like this 00:00:01.

    and if its possible to change the caption of CommandButton to Start as Default then once click it will change to Pause vice versa.

    Thank you,

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Excel VBA Timer

    You can apply an IF statement to decide the code you would like to run under the same Sub.

    So
    Please Login or Register  to view this content.
    Last edited by PFDave; 07-18-2017 at 04:43 AM.
    Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back

    Please also mark your thread as solved once it has been.

  3. #3
    Registered User
    Join Date
    03-07-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    182

    Re: Excel VBA Timer

    Thank you, Any input on how to create the countdown timer?

  4. #4
    Registered User
    Join Date
    03-07-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    182

    Re: Excel VBA Timer

    I put this code under CommandButton

    Please Login or Register  to view this content.
    but its not working properly. Thanks for the inputs

+ 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. timer for 30 minutes and timer based events
    By mohak12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2014, 06:20 PM
  2. Timer in Excel
    By anthony_91 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2013, 04:54 PM
  3. TIMER in Excel
    By vinayjan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2013, 09:46 PM
  4. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  5. Timer in Excel
    By deldes29 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2010, 10:12 AM
  6. Replies: 1
    Last Post: 03-10-2006, 08:10 AM

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