Hello,
I'm trying to add a simple progress indicator to my code. I'm using instructions from this website. The only difference is instead of activating it via a CommandButton, I add another Sub called ShowForm which I add to my main code.
The problem is, the instruction in the link shows how to create progress indicator based on numbers. The example code creates numbers in cells and the level of completion of these numbers serves as information for the progress bar what's the progress in %. Here's how it looks like:
pctCompl is i which in this example are numbers.
My code does not calculate numbers. It copies data from another sheet, reformats cells (removes unnecessary blanks, adds columns etc.) and saves the formatted data into a new workbook.
What should I assign to pctCompl so that I'm able to show progress?
Bookmarks