+ Reply to Thread
Results 1 to 2 of 2

Excel VBA Progress Bar 2007 Workbook_Open Between calls

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Excel VBA Progress Bar 2007 Workbook_Open Between calls

    Good day,
    I am looking in searching on information for VBA Progress Bar. I have some example of code that I cannot seem to change to my needs.

    I have on a VBA Progress Bar, Workbook_Open, some fuctions that will be called.

    Example:
    Please Login or Register  to view this content.
    My biggest threat is my Call complist that will open another workbook to update the list I have in one of my sheets.

    Is there a way to incorporate the following example of VBA Progress Bar to match my call proceedures? Meaning, the progress bar will show the status by call completed...

    from 0% to 100%, make the progress bar advance everytime a call is complete.

    This was taken from the following website: http://www.learnexcelmacro.com/wp/20...-in-excel-vba/

    Please Login or Register  to view this content.
    Progress_Bar.xlsm
    Click the star icon in the lower left part of the contributor's post and add Reputation if we have helped you .

  2. #2
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Excel VBA Progress Bar 2007 Workbook_Open Between calls

    Found a solution:

    UserForm:

    Please Login or Register  to view this content.
    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. 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
  2. Excel 2007 Workbook_open not working
    By kpatil83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2013, 04:35 AM
  3. Replies: 2
    Last Post: 06-29-2011, 04:35 PM
  4. Progress Meter In Excel 2007
    By striker_rage in forum Excel General
    Replies: 7
    Last Post: 07-17-2010, 06:28 AM
  5. Excel 2007 workbook_open events are not working
    By ljoseph in forum Excel General
    Replies: 1
    Last Post: 05-11-2010, 01:51 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