Hi guys,
I have a userform that loads when I open my document, I click a few things on the userform and when I click Start it enters a few variables into a sheet called "Toggles" (not 100% needed), it then calls RUNALL() which has a list of about 50 macros in it, they're all linked up to run in a specific order and takes about 30 mins to complete.
I would like a progress bar with the percentages/updates incremented based on every macro ran...
So lets say we have 10 macros, at first I was thinking of a userform that looked like a progress bar and for every time a macro runs me to have a line of code that does: "UserForm.Update.Width = UserForm.Update.Width + 10" or something like that
I tried doing a conditionally formatted cell as that one is easier to do but for some reason regardless of what I do to the cell I can't get the data bar to show correctly, it sits at 50% green, 50% white...
Any idea how I can create a progress bar for this?
Bookmarks