I have a macro that takes about a minute to run. I would like to add a progress bar to appear once the macro starts running. There are no loops in the macro. What are my options?
I have a macro that takes about a minute to run. I would like to add a progress bar to appear once the macro starts running. There are no loops in the macro. What are my options?
Why does it take a minute to run?
A simple solution would be to indicate the status using the status bar in the lower left. Use a percentage or a text-bar like the example below. Put each status bar change at various points in your code.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks for your help...your method worked out just fine. In the process I cleaned up the macro so that it now runs for 20 seconds. Between that and your progress coding it all works well. Thx for your help!
Change the "20" to "600" if you want it to take a minute...
Please Login or Register to view this content.
Last edited by Xx7; 03-11-2014 at 02:18 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks