R
RDallas
Hope you can help, I have created a UserForm with multiple
CommandButtons, each CommandButton runs a lengthy Macro.
The Code for the Macro is running inside a loop that
updates a ProgressBar. I have this process running perfectly.
After you click the CommandButton, the Macro is in perfect
sync with the completion of the ProgressBar reaching 100%,
except that when the Userform that displays the ProgressBar
is instructed to unload, it unloads leaving a white area
where the UserForm was. The white area doesn't completely
disappear until the worksheet updates all of the changes,
about 12 seconds.
How can I make the UserForm remain displayed with the 100%
finished ProgressBar while the worksheet finishes it's 12
seconds of updating?
CommandButtons, each CommandButton runs a lengthy Macro.
The Code for the Macro is running inside a loop that
updates a ProgressBar. I have this process running perfectly.
After you click the CommandButton, the Macro is in perfect
sync with the completion of the ProgressBar reaching 100%,
except that when the Userform that displays the ProgressBar
is instructed to unload, it unloads leaving a white area
where the UserForm was. The white area doesn't completely
disappear until the worksheet updates all of the changes,
about 12 seconds.
How can I make the UserForm remain displayed with the 100%
finished ProgressBar while the worksheet finishes it's 12
seconds of updating?