Want MsgBox to disappear at end of sub (not after xx seconds)

We have a rather complex spreadsheet, and some of the macros perform queries and filters and other things to up to thirty worksheets or more, and can take up to twenty or thirty seconds.

In order to speed things up, I've turned off screenUpdating on several of the macros, but this creates the issue of normies staring at a monitor that is apparently doing nothing. I'd like to start off with a msgBox advising the user to sit tight, and then disappear at the end of the sub when screen updates are turned back on. Possible?

Excel version 2403

There are a number of possibilities:

• Create a userform with your message on it, show it before running and then unload it at the end.
• Display a "Done" message at the end using the inbuilt MsgBox function
• Change the cursor to an egg-timer while the code is running
• Use DoEvents periodically to refresh the screen and update the statusbar with the progress.

I was completely unaware of the egg timer option, that will do the trick just fine, thanks,

Show the egg timer: Application.Cursor = xlWait
Go back to pointer: Application.Cursor = xlDefault