+ Reply to Thread
Results 1 to 2 of 2

Excel Progress Bar for macros

  1. #1
    Registered User
    Join Date
    05-10-2017
    Location
    Denver, Colorado
    MS-Off Ver
    2016
    Posts
    11

    Excel Progress Bar for macros

    Hello,

    I am running 1 macro that runs multiple other macros from various other Excel workbooks that takes around 10 minutes. I would like to enter a progress bar (via user form or status bar) that shoes the progress of my macro so the end user can view it once executing the macro.

    I understand how to create the userform for the progress bar (with labels and frames), but I just can't figure out how to get it updating based on events in my VBA. I have looked relentlessly online and I just can't figure it out. Do I have to put my code for the macro inside the userform? Or do I have my userform and macro code separate, but insert code that updates the progress bar directly in my macro code?

    What I would like is potentially a small example showing how to do this. Here is some example code that better resembles the structure of my macro...
    Please Login or Register  to view this content.
    etc...

    So essentially I would need the progress bar after workbook a and before workbook b (where SPACE is indicated above).

    I would appreciate any help!
    Last edited by 6StringJazzer; 07-14-2017 at 07:09 PM.

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

    Re: Excel Progress Bar for macros

    Each macro needs to be modified the calculate its progress, and periodically call a procedure in the workbook containing the progress form to update the display.
    Entia non sunt multiplicanda sine necessitate

+ 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] Message when VBA works; Be patien etc..; Is possible progress bar on progress information?
    By martin81 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-30-2016, 08:43 AM
  2. Progress bar for running Macros.
    By singerbatfink in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2016, 06:57 AM
  3. Replies: 1
    Last Post: 08-06-2014, 10:29 PM
  4. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 01-08-2014, 02:40 AM
  5. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 12:41 PM
  6. [SOLVED] Progress bar for Macros
    By bwood7 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2013, 06:18 PM
  7. Help, Progress bar with multiple macros
    By greenfalcon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2006, 03:05 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