Hello,
I am running 1 macro that runs multiple other macros from various other Excel workbooks that takes around 10 minutes. I would like to enter a progress bar (via user form or status bar) that shoes the progress of my macro so the end user can view it once executing the macro.
I understand how to create the userform for the progress bar (with labels and frames), but I just can't figure out how to get it updating based on events in my VBA. I have looked relentlessly online and I just can't figure it out. Do I have to put my code for the macro inside the userform? Or do I have my userform and macro code separate, but insert code that updates the progress bar directly in my macro code?
What I would like is potentially a small example showing how to do this. Here is some example code that better resembles the structure of my macro...
etc...Please Login or Register to view this content.
So essentially I would need the progress bar after workbook a and before workbook b (where SPACE is indicated above).
I would appreciate any help!
Bookmarks