+ Reply to Thread
Results 1 to 7 of 7

Set countdown timer, then pop-up message when complete

  1. #1
    Registered User
    Join Date
    10-22-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    19

    Set countdown timer, then pop-up message when complete

    As the title suggests, I want to be able to have two separate cells C14 and C15, where I can set countdown timers by entering the value in hours and minutes (HH:mm, for example at 3pm means 15:00) in each and receive a pop-up message when timer is complete. I want both cells to operate independently from each other and countdown on separate timers and receive separate pop-up messages.

    So far I've had no luck finding the right code to pull this off... So I'm coming to you all for help
    Last edited by aftbrah; 10-28-2016 at 05:59 PM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Set countdown timer, then pop-up message when complete

    On short order and a quick search around the net, this is what I've come up with so far. Hopefully this will get you started where you want to go.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-22-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    19

    Re: Set countdown timer, then pop-up message when complete

    Nice! Would I be able to set the timer for a specific time, rather than a time interval? Like setting it for 10pm.

    Also, can I get rid of the buttons and simply have the timer begin as soon as the value is entered in the cell, and then stop the timer if the value is deleted from the cell?

    Thank you so much for all the help you have already given me

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Set countdown timer, then pop-up message when complete

    Here is something closer to what you are looking for. I encourage you to search the internet and this forum for additional code that you can test in the two files I've presented, to accomplish what you are
    seeking. Its a great learning experience. These two files will give you a head start.

    Let us know how you progress.

    Cheers.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-22-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    19

    Re: Set countdown timer, then pop-up message when complete

    thank you so much for all the help!

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Set countdown timer, then pop-up message when complete

    Your welcome. If you are satisfied with all replies, please mark this thread SOLVED.

  7. #7
    Registered User
    Join Date
    10-22-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    19

    Re: Set countdown timer, then pop-up message when complete

    Marked as Solved. Thank you very much!

+ 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. Countdown timer
    By Trickypottermus in forum Excel General
    Replies: 3
    Last Post: 11-13-2013, 08:09 AM
  2. [SOLVED] Countdown timer
    By flyinghigher2011 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-10-2013, 03:08 PM
  3. timer to countdown
    By Burt_100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2013, 07:27 AM
  4. countdown timer
    By pka in forum Excel General
    Replies: 0
    Last Post: 10-23-2011, 09:18 AM
  5. Countdown Timer
    By gkokaisel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2011, 08:02 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