+ Reply to Thread
Results 1 to 6 of 6

VBA Progress Bar

  1. #1
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    161

    VBA Progress Bar

    Afternoon all,

    So I've googled VBA progress bars and all the examples I've found don't really do what i'm after (Or i can't adapt them to show me what i want )

    I was hoping someone could help me with one please?

    Please Login or Register  to view this content.
    sFile = Looped range of names (11 in total)

    What I am after is just a userform that pops up (Do i move this code to the UserForm_Initialize? or trigger the macro when opening??) that tells the user which file is currently downloading.

    Seems simple... Maybe it is, but i can't get anything working

    Any help would be fantastic!

  2. #2
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: VBA Progress Bar

    Anyone got any ideas? Other than message boxes

  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow

    Hi !

    An idea : many samples on web, whatever in blogs or forums, even here so Google is your friend !

    And you must notice often the classic VBA progress bar using an UserForm may very slow down the execution …

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: VBA Progress Bar

    Quote Originally Posted by Marc L View Post
    Google is your friend !
    That is not a helpful answer. If you don't have specific help to offer, please know that we all know about Google.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: VBA Progress Bar

    sFile = Looped range of names (11 in total)

    What I am after is just a userform that pops up (Do i move this code to the UserForm_Initialize? or trigger the macro when opening??) that tells the user which file is currently downloading.
    I can offer a progress bar that I have built but to understand how to integrate it to your code, I need to understand what you want to measure. Do you want an actual bar that shows progress from 1-11? Or just a message that shows which file is currently downloading?

    The strategy is to create a UserForm and set ShowModal to False so it can be displayed while the process runs. The form will have a Label on it. You Show the form before your loop starts. Each time through the loop you update the label to show the current file name. Then after the loop you Hide the form.

    If you want to show a bar, then it's a bit more work to set that up on the form.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: VBA Progress Bar

    Quote Originally Posted by Marc L View Post
    Hi !

    An idea : many samples on web, whatever in blogs or forums, even here so Google is your friend !

    And you must notice often the classic VBA progress bar using an UserForm may very slow down the execution …
    Marc, if you are not going to offer actual help to members - rather than just telling them to go look it up - then dont even bother to respond. I have received many complaints about you, regarding this. Remember, not all members are even above beginner level here, your cryptic remarks helps nobody, so either offer help or dont respond.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 1
    Last Post: 08-06-2014, 10:29 PM
  3. [SOLVED] Progress Bar Down from Existing Progress Bar Up
    By iqballud in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-06-2014, 05:05 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. Progress Bar
    By mtclimber in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2009, 06:46 PM
  7. [SOLVED] NEED Help - How to capture the Event's progress in Progress Bar
    By Sriram in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2006, 07:10 AM

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