View original (French)

Waiting message during macro execution

tienou -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   -
Hello,
To hide the tasks executed by the macro, I set at the beginning: Application.Visible = False

Then at the end of the macro: Application.Visible = True

For the "Please wait while processing" window, I included a Userform1.Show at the beginning of the macro and at the end of the macro Unload Userform1

But the userform does not close at the end and remains displayed.

Does anyone have a solution? Thank you in advance.

Configuration: Windows / Mozilla 11.0

2 réponses

Réponse 1 / 2
Maurice
 
Hello

I'm thinking more of something like this 
 Sub Test() UserForm1.Show 0 Application.ScreenUpdating = False ' ' ' Application.ScreenUpdating = True Unload UserForm1 End Sub


See you
Maurice
0
Réponse 2 / 2
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
Hello

Try this

Display a message "please be patient. Deletion in progress..."

Application.StatusBar = "please be patient. Deletion in progress... "

Clear the message

Application.StatusBar = False

--
Practice makes perfect. - It's when you're up against the wall that you see the bricklayer - one always learns from one's mistakes.
0