VBA "Please Wait" message while macro is running

[StupidCoffee]

Hi

I am trying to show a message that says "Please Wait" while the macro is processing.
I tried loading a userform, but the macro seems to stop while the userform is open.
I want my userform to remain on screen until the process ends, then closes itself.

By far I had :

Sub summary()

UserForm1.Show
Application.ScreenUpdating = False

Call Code 'Macro I want to run

Application.ScreenUpdating = True
Unload UserForm1

MasgBox "Process Completed"

End Sub



Please Help

 

[VoG]

Try

UserForm1.Show vbModeless