Excel: Can I add a msgbox or something while is finishing a procedure?

[RovirozM]

Hi Guys,

Just curious, I have an Excel Application that when I push a command button it runs severals processes (Around 30-45 seconds).

Can I put a messagebox that says "Be patient.. etc" and then when the process finish to release this messagebox?

It is because takes time and just the hour glass mouse pointer is there but not so visible...

Thanks!

 

[GlennUK]

Use a modeless userform.

Create a userform with the required message, and change its ShowModal property to false.

Put a call to your main processing in the userform activate event, like:

Private Sub UserForm_activate()
    DoMyProcessing
End Sub

and put a

DoEvents

in the beginning of your main processing, and a

Unload UserForm1

at the end.

Make you command button show the user form, like:

UserForm1.Show

That should do it.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[combo]

You can display messages with Application.StatusBar too (in case of loop the percentage done for instance).

combo