User Form And Temporary Popup

  • i have a code that calls for a userform to load. seen below - i want a temporary popup window to come up and while the code is running. i get an error everytime becuase you can not show a vbmodeless form with a userform. any ideas on how to fix this?

    Private Sub Workbook_Open()
    Application.Visible = False
    End Sub
  • Re: User Form And Temporary Popup

    What do you need Randomize for?

    I would not recommend hiding the Application, you could cause problems for your users if the application crashes & leaves a hidden instance of Excel running.

    I don't think that you can display a messagebox whilst code is running, this interrupts the code.

  • Re: User Form And Temporary Popup

    Instead of a message box you could use a userform with your message on it as a label. The code would run with the userform/message showing, and the same code could have a line to unload the form at the appropriate point.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!