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?

    Code
    Private Sub Workbook_Open()
Randomize
Application.Visible = False
MASTER.Show
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!

Register Yourself Login