User Form displayed while macro is running, close when finished.

[Paul_K]

Hello everyone,
I have a macro which take a few seconds to run and I want something to show on the screen so the user knows something is happening.
I don't want to use the Status bar because it's often missed by the users.

I have a Userform set up with text "Processing Please Wait", and have used PleaseWait.Show at the start of the macro and PleaseWait.Hide at the end.
However the macro doesn't run any further than PleaseWait.Show until the red X is clicked on the UserForm, which defeats the point.

Is there a way to have the Userform show while the macro is running and disappear at the end of the macro without any user input?

Thanks in advance.

 

[Fluff]

Take a look at this & see if it helps
Excel Tips From John Walkenbach: Displaying A Progress Indicator

 

[Paul_K]

Take a look at this & see if it helps
Excel Tips From John Walkenbach: Displaying A Progress Indicator

I found that, but it's way more complex that I need.

 

[dmt32]

try

PleaseWait.Show vbModeless

Dave

 

[xenou]

Also you can kick off the macro from within the userform - then the userform can also have the userform close itself when it completes.

(personally I'd prefer the status bar approach and the users suffer if they are too stupid to be able to understand a status bar).