Can I display something while the macro is running?

Question

I have a macro that takes about five seconds to execute, and I'm using Application.ScreenUpdating = False code, so it looks like Word is locked when it works.

I use the message box at the end to let them know that it is complete, but I would like to display an image during its execution that tells the user to run the macro (first of all, so that they don’t worry, but also because it’s better consider).

There may be an easier way to do this, but I decided to create an image, create a very simple custom view and just set my image as a background. Then I get this custom form as soon as the code starts working.

The problem I am facing is that if I do not close it, the rest of the code will not be executed. It just freezes until I do nothing. Is there a way so that I can display the user form without stopping the rest of the process? If not, is there any other approach I can take to display the image while the macro is running?

Answer 1

You can show the custom form as non-modal:

 Userform1.Show False 'do more stuff (doesn't wait for form to close) Userform1.Hide