+ Reply to Thread
Results 1 to 2 of 2

Displaying output of countdown timer

  1. #1
    Registered User
    Join Date
    05-03-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    23

    Cool Displaying output of countdown timer

    Hello All,

    I am a real newbie when it comes to VBA so please excuse me if I don't use the correct terminology

    I have this script that is a 15 minute countdown timer:

    Sub SetTime()
    DownTime = Now + TimeValue("00:15:00")
    Application.OnTime DownTime, "ShutDown"
    End Sub

    Sub ShutDown()
    ThisWorkbook.Save
    ThisWorkbook.Close
    End Sub

    The countdown timer will run "Shutdown" (which saves and closes an excel workbook) after 15 minutes of inactivity. I would like to display the current value of "Downtime" in a cell in my spreadsheet so that people know how much time they have left before the excel workbook closes.

    I've looked all around but can't find anything....probably because i'm not sure what this would be called.

    Thanks so much for any help you can provide,
    Ced

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Displaying output of countdown timer

    Does this help?

    http://ramblings.mcpher.com/Home/exc...progress-timer

+ 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. Displaying a unique countdown timer with Start/Stop/Reset buttons on multiple lines
    By drememagik in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2017, 07:51 PM
  2. timer to countdown
    By Burt_100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2013, 07:27 AM
  3. Countdown timer
    By Badding in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2010, 08:41 PM
  4. Countdown Timer
    By colt seavers in forum Excel General
    Replies: 3
    Last Post: 01-12-2010, 12:23 PM
  5. Countdown timer
    By Nemeo in forum Excel General
    Replies: 1
    Last Post: 05-24-2007, 09:37 PM

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