I am building a macro that deals with a lot of data and takes several minutes to run. I want to display a message to the user stating "Calculating..." while the calculating is taking place. I got the idea to use a userForm with a label on it. The problem is that excel waits for input from the userform before continuing the calculations.
How do I display the userform, continue doing the calculations, and then hide the userform when the calculations are complete? (without any input from the user)
I currently have:
Bookmarks