+ Reply to Thread
Results 1 to 2 of 2

Simple Progress Meter

  1. #1
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    39,636

    Simple Progress Meter

    Andy Pope has a lovely collection of progress meters at https://www.andypope.info/vba/pmeter.htm. For something a little more simple-minded, here's one that translates percent complete to a display in a cell or on the status bar like this:

    Progress: ||||||||||||||||||||||||.....'.........'.........'.........'.........'.........'.........'.........' ET: 0:00:10 ETC: 0:00:33 ETT: 0:00:43

    There are options to show percent complete numerically (not shown above), and options to show the elapsed time, estimate to complete, and estimated total time (all shown above).

    Here's the code:

    Please Login or Register  to view this content.
    A progress meter is supposed to show progress, not impede it, so you don't want to call it a zillion times. So for example,

    Please Login or Register  to view this content.
    Adjust the divisor so it updates every second or two.

    if you display the progress bar in a cell, I suggest you format with a mono-spaced font like Consolas so it maintains constant width.

    I hope someone finds it useful.
    Last edited by shg; 12-22-2018 at 12:35 PM.
    Entia non sunt multiplicanda sine necessitate

  2. #2
    Registered User
    Join Date
    10-29-2017
    Location
    Delhi
    MS-Off Ver
    10
    Posts
    25

    Re: Simple Progress Meter

    Thanks, Excellent Explanation, Got It.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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