View original (French)

Waiting message during macro execution

tienou -  
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 answers

  1. 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
    1. PHILOU10120 Contributor
      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.