+ Reply to Thread
Results 1 to 2 of 2

Userform Multiple Countdown Timers

  1. #1
    Registered User
    Join Date
    10-09-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Userform Multiple Countdown Timers

    Hello,

    I'm trying to create a userform with multiple timers which I can trigger at different times. Below is the code that I have. Here is what I'm trying to do:

    Capture.PNG

    The 3 timers that are on there work fine, but the userform locks and I can't toggle any of the buttons to start the timers I want. Any ideas why this is happening?

    P.S. The only way to exit the userform is to hit escape, the timer then counts up/down to the target quickly then the userform exits.


    Thanks!



    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Userform Multiple Countdown Timers

    You are using the wrong Timer application.

    It is in the name. Application.Wait this is designed to stop the macro and wait.

    Eg for a file to print.

    You should be using OnTime.

    I will post a simple sample for you to study.
    Attached Files Attached Files
    Last edited by mehmetcik; 02-12-2015 at 08:25 AM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. Best way to make multiple countdown timers
    By Dave_ross in forum Excel General
    Replies: 19
    Last Post: 02-04-2019, 05:06 PM
  2. Countdown timers.
    By saintdave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2014, 04:47 PM
  3. Multiple Countdown timers.
    By dawidski in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2013, 11:42 PM
  4. multiple countdown timers in excel?
    By hollandrob81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2013, 04:12 PM
  5. Countdown Timers?
    By phil2006 in forum Excel General
    Replies: 2
    Last Post: 09-11-2007, 07:00 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