+ Reply to Thread
Results 1 to 2 of 2

Progress Bar UserForm and/or Progress Bar Conditional Formatting

  1. #1
    Forum Contributor
    Join Date
    09-07-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    358

    Progress Bar UserForm and/or Progress Bar Conditional Formatting

    Hi guys,

    I have a userform that loads when I open my document, I click a few things on the userform and when I click Start it enters a few variables into a sheet called "Toggles" (not 100% needed), it then calls RUNALL() which has a list of about 50 macros in it, they're all linked up to run in a specific order and takes about 30 mins to complete.

    I would like a progress bar with the percentages/updates incremented based on every macro ran...

    So lets say we have 10 macros, at first I was thinking of a userform that looked like a progress bar and for every time a macro runs me to have a line of code that does: "UserForm.Update.Width = UserForm.Update.Width + 10" or something like that

    I tried doing a conditionally formatted cell as that one is easier to do but for some reason regardless of what I do to the cell I can't get the data bar to show correctly, it sits at 50% green, 50% white...

    Any idea how I can create a progress bar for this?

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Progress Bar UserForm and/or Progress Bar Conditional Formatting

    Why bother with a progress bar when you can simply use a statusbar message indicating Macro XX of 50 or something?

    https://www.google.com/webhp?sourcei...userform%20vba
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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] Progress Bar (conditional formatting)
    By Blackhawks in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-16-2014, 03:00 PM
  2. 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
  3. 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
  4. [SOLVED] Conditional Formatting - Progress Bar based on dates in row
    By RichTea88 in forum Excel General
    Replies: 3
    Last Post: 01-24-2013, 08:50 AM
  5. how to create a progress bar in conditional formatting.
    By boyabo in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-28-2012, 12:54 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