I have a complex macro that takes several seconds to complete. It is activated by clicking the "Close & Save" command button in UserForm19. Due to the delay while the macro is working, I'd like to create a "Loading..." message that will let the user know that the macro has started and to please wait. Otherwise, it looks like Excel has frozen.
I started with a blank user form that just has a bolded label stating, "Loading... Please Wait.", but I can't get it to pop up overtop of the original user form (UserForm19) while the original user form is still performing the macro. Ideally I'd like the user to click the "Close & Save" button, the "Loading..." window would pop up over top of UserForm19, and then automatically go away at the same time as UserForm19 after all of the actions in the macro have been completed. Like I said, my attempts at this caused the original macro to pause until the user closed the "Loading..." user form, or the same when I tried it as a message box.
I started with a blank user form that just has a bolded label stating, "Loading... Please Wait.", but I can't get it to pop up overtop of the original user form (UserForm19) while the original user form is still performing the macro. Ideally I'd like the user to click the "Close & Save" button, the "Loading..." window would pop up over top of UserForm19, and then automatically go away at the same time as UserForm19 after all of the actions in the macro have been completed. Like I said, my attempts at this caused the original macro to pause until the user closed the "Loading..." user form, or the same when I tried it as a message box.