Macro Progress Indicator

**crs245** · 08-20-2009, 03:23 PM

I have seen this: http://spreadsheetpage.com/index.php...ess_indicator/ and Andy Pope's website, but I am having trouble linking the progress up to my macro. Let's say I have some nested Macros, Macro3 is within Macro2 which is within Macro1.

I want to be able to run Macro1, and have a progress bar update from 0 to 100% as it calls Macro2 which loops through some stuff as it calls Macro1 which goes through its own loop.

Basically, my progress indicator code is the following...

Please Login or Register  to view this content.

The progress bar is called LVprogress and it has its own code:

Please Login or Register  to view this content.

I am at a loss at how to hook all of this up to my compound macro.

**crs245** · 08-26-2009, 01:58 PM

Anybody?

**royUK** · 08-26-2009, 02:37 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Macro Progress Indicator

LinkBack

Thread Tools

Rate This Thread

Display

Macro Progress Indicator

Re: Macro Progress Indicator

Re: Macro Progress Indicator

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions