+ Reply to Thread
Results 1 to 3 of 3

Progress bar for running Macros.

  1. #1
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Progress bar for running Macros.

    Hi Ive looked on this forum for an answer but no luck.

    I have a macro that opens up to 83 workbooks and copies data into a master workbook. It can take a while and Id likeprogess bar to show the elapsed/remaining time. Ive tried:

    Please Login or Register  to view this content.
    But thats not what im looking for.

    Here is my code.

    Please Login or Register  to view this content.
    Thanks
    B

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Progress bar for running Macros.

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

  3. #3
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Re: Progress bar for running Macros.

    Hi PFDave Thanks for your link it was really useful. Ive got it set up up and the Userform appears onscreen when the code starts and disappears when it ends but the progress bar does not appear at all. Can you help me work out why. Im still learning code and this has beaten me.

    Ive added the aditional code at the end on this module.

    Please Login or Register  to view this content.

+ 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] Hiding the file when running macros and after running macros
    By thilag in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2016, 07:15 AM
  2. Progress Bar When Running Macro
    By ACE23 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-01-2015, 08:01 PM
  3. [SOLVED] Progress Bar while Macro is Running
    By Pony08 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2014, 12:01 PM
  4. Status/Progress Bar while running macro
    By tnuis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2013, 10:58 AM
  5. no blinking when running and progress bar
    By mqdias in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2011, 01:35 PM
  6. progress box while macro is running
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2005, 06:05 AM
  7. [SOLVED] how do you set up a progress bar when running a macro in excel?
    By Neil Hopkinson in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-03-2005, 06:06 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