+ Reply to Thread
Results 1 to 2 of 2

Donut Style Progress Indicator not executing while other code is running

  1. #1
    Registered User
    Join Date
    11-22-2013
    Location
    los angeles ca
    MS-Off Ver
    Excel 2013
    Posts
    1

    Donut Style Progress Indicator not executing while other code is running

    Hey, I have been using the traditional progress indicator for some time now and am interested in a new design. I have created a new progress indicator style similar to the one we see in other windows applications ( The donut graph with 4 slices). I am wondering if it is possible to create a standalone progress indicator that runs independently of other procedures. For instance, I can create a progress indicator that is "Updated" everytime a loop reaches a certain point by calling the procedure, at which case the procedure will focus its attention on updating the progress bar then once the progress bar "Updated" event occurs, it will continue the look. As you can imagine, this is not realistic with a Donut style indicator because the slices need to be timed so that the circular sliced rotate. However, I have not found anyway to "execute two loops at the same time" ( not in succession). I have the following format so far, but I somehow am looking to overcome the fact that so far I am limited to one loop at a time.



    I have attached what I have come up with so far. It is a worksheet with a few buttons that imitate what I would like to see...hope an MVP out there knows the answer!
    Issue; after pressing "Show Progress Indicator" in my spreadsheet, then pressing "Random Value Setting", the wheel stops spinning
    I think we can all use an updated progress bar..
    here is my module code

    Please Login or Register  to view this content.
    I also have a userform event procedures

    Please Login or Register  to view this content.
    The userform basically has 8 jpeg images that rotate from being visible to being false. THey all overlap eachother... In summary, I would like the timed donut rotation to occur while other code is executing, with the donut rotation stopping only once the entire main procedure has ended. I can imagine others would like this type of feature?
    Attached Files Attached Files
    Last edited by UCAnalytics; 11-22-2013 at 03:48 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Donut Style Progress Indicator not executing while other code is running

    best way to do this is to use a animate gif. You can then display that in a webbrower control on a userform.

    The only issue then would be supplying the gif with the workbook.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-22-2013
    Location
    los angeles ca
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Donut Style Progress Indicator not executing while other code is running

    I tried embedding a windows internet control in a Userform and them navigated to a GIF file. Unfortunately, the image "Pauses" every time i execute the macro. I feel like this is a question of "Asynchronous" execution?

+ 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. Clock Chart (overlapping donut style)
    By reynoldsohio in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-28-2013, 07:19 AM
  2. long running macro - progress indicator tips needed
    By jmac1947 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2012, 01:02 AM
  3. [SOLVED] VBA code running in wrong order and not executing properly
    By ollylondon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2012, 10:11 AM
  4. Status bar progress indicator stops updating part way through code execution.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2012, 07:45 PM
  5. Progress Indicator
    By excel_lover in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2009, 04:59 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