+ Reply to Thread
Results 1 to 2 of 2

Display progress in Application.StatusBar

  1. #1
    Registered User
    Join Date
    08-22-2011
    Location
    Berlin
    MS-Off Ver
    Excel 2010
    Posts
    51

    Display progress in Application.StatusBar

    I've found a lot to this in many places but nothing really comprehensive and thus have made an effort to implement a common solution in a class module called clsMSBPrgrs which can be found in the Workbook ASBPrgrs.xlsm. It is able to display the progress of any number of sequentially called or nested processes (usually loops of any kind), either together with a variable that illustrates the progress or, if there is none sensible variable, to automatically display dots instead.
    Calling the progress display is just one statement like:
    Please Login or Register  to view this content.
    wherby i may be the loop iterator. The .Dsply method of the class ensures the update of the Application.StatusBar even for very long processes with thousands of iterations. The class has several properties to "configure" the progress display before it is used the first time which looks as follows:
    Please Login or Register  to view this content.
    If this sounds interesting I would be happy for any reply regarding its usefullness (once it has been tried of course). In case any help for using/integrating it in your project, please let me know.
    P.S.: The Workbook ASBPrgrs.xlsm also features a performance test and demo.
    Last edited by Warbe; 11-14-2015 at 05:03 PM. Reason: Property SubProcessesMax renamed in MaxSubProcesses

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Display progress in Application.StatusBar

    Impressive. Well done.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. StatusBar Progress
    By Silencer116 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2016, 02:42 PM
  2. Excel 2013 Application.Statusbar not working
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2015, 09:25 AM
  3. Application.MacroOptions: StatusBar property not working
    By greglittle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2012, 12:56 AM
  4. Can Application.Screenupdating prevent StatusBar message from being updated?
    By m3atball in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2012, 06:20 PM
  5. Application.Statusbar not updating correctly
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2011, 03:13 AM
  6. Change font color of Application.StatusBar
    By noliveira in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2008, 09:16 AM
  7. How to reset the Application.StatusBar
    By PCLIVE in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-01-2006, 12:18 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