I have been trying to inform users about the status of a
macro through a UserForm.

Unfortunately when I put the form on screen at the start
of the macro the form appears but the content is blank.
The macro runs then the form disappears, with the user
never seeing what is on the form.

How do I force Excel to wait for the whole form to be
displayed before proceeding with the rest of the macro?

I tried using the command Application.ScreenUpdating =
False but it didn't help.