+ Reply to Thread
Results 1 to 3 of 3

Progress Bar or Timer or Stop Watch

  1. #1
    Registered User
    Join Date
    07-12-2005
    Location
    Canberra, Australia
    MS-Off Ver
    2007
    Posts
    43

    Progress Bar or Timer or Stop Watch

    I have created a macro that takes a long time to process. A lot of this time is because Excel is re-calculating.
    I would like the user to know how much time has expired and (because I know how long the process takes on average to complete) how much time is left.
    I would like to either include a progress bar or a timer or stop watch, but I don't think it would update during those times when Excel is re-calculating - which is most of the time.
    Is it possible to overlay (if that's the right word) a progress bar or timer or stop watch on top of the spreadsheet that is in some way independent of Excel - i.e. it doesn't stop when Excel is calculating?
    I hope that makes sense.
    Many thanks
    David

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Progress Bar or Timer or Stop Watch

    There are numerous ways to do this. Just a few

    http://spreadsheetpage.com/index.php...ess_indicator/

    http://www.andypope.info/vba/pmeter.htm

    http://archive.oreilly.com/pub/h/2607

  3. #3
    Registered User
    Join Date
    07-12-2005
    Location
    Canberra, Australia
    MS-Off Ver
    2007
    Posts
    43

    Re: Progress Bar or Timer or Stop Watch

    Thanks very much walruseggma. I haven't tried them yet, but those examples look like they are exactly what I am after.
    I appreciate you replying.
    Regards,
    David

+ 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. [SOLVED] Label as Progress Based On Timer
    By iqballud in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2014, 02:48 PM
  2. stop watch
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2014, 01:09 PM
  3. Stop Watch
    By Mr.India in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2013, 11:02 AM
  4. stop watch and timer in excel
    By Suraj3825 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2013, 05:50 AM
  5. Replies: 1
    Last Post: 12-12-2012, 08:46 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