Progress Indicator

**excel_lover** · 08-19-2009, 11:07 AM

Hi,
Im following the tutorial at JWalks website -

Please Login or Register  to view this content.

It looks great on the userform but I dont know how to get it to work and scale to the macro. My macro is a very simple on but a very long one. The macro will start off distributing some numbers found in column AE on my sheet named Matrix. The cells are between AE4 and AE535 each cell will start with a number but then turn to a zero. Each one of the 531 cells will take the same time to turn to 0.00 as each line in the spreadsheet is processed so 50% will display with around 265 zeroed cells.

How do I capture this and code for the example?
Many Thanks

**excel_lover** · 08-19-2009, 03:37 PM

Hi ive made some progress with incorporating this.. Please can you comment on how to alter the last bits of code

Ive got UserForm_activate() calling my macro below

Please Login or Register  to view this content.

The form (frmProgress) is visible when the macro is running and

Please Login or Register  to view this content.

removes the form when its finished. The problem is the progress counter doesnt update.

Looking into the code I found written by JWalk it comes with sample code below to update the counter.

Please Login or Register  to view this content.

I know this has what I need to incorporate loosely held within but im not sure how to incorporate it with my code.

I know I need the a scalable loop and in my code I explicitly state

Please Login or Register  to view this content.

Each row in rngDistr takes roughly the same time to process. Please can anyone help me with incorporating the code and scaling the form output.

Many Thanks

**Andy Pope** · 08-20-2009, 04:18 AM

You need to place the update of the progress bar code within your loops.

Please Login or Register  to view this content.

**Andy Pope** · 08-20-2009, 04:59 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!