macro message box

[JasonLeVan]

Is there a way to have a message box pop up but continue running the rest of my macro

 

[capparfrank]

Jason,

The important term you want to know is 'Modal.' A modal form or dialog is one that is going to cause it's parent to stop running until its own process is finished (sorry if you knew that already).

I am pretty confident that that VBA msgbox is always modal. There's no way to put one on the screen and have the macro that created it continue running.

However, Userforms can be non-modal. You can set up a userform to look a lot like a msgbox, if you want.

UserForm1.Show vbModeless

There may be better solutions, but this is how I'd do it. Remeber that you'll have to figure out when you want the userform to go away and either hide or unload it as necessary.

 

[Andrew Poulsom]

No, a message box is modal.

 

[Jon von der Heyden]

Do you mean show a msgbox, dismiss it automatically and then continue with the rest of of the macro? If so, this will display a msgbox for 2 seconds, dismiss and then run the rest of the macro.

Public Sub test()
    Dim objWShell As Object, i
    Set objWShell = CreateObject("Wscript.Shell")
    
    objWShell.Popup "Boo!", 2
    
    'rest of macro
    
    MsgBox "done"
End Sub

 

[JasonLeVan]

this will work great, how do i hide it when i am done with the display

Jason,

The important term you want to know is 'Modal.' A modal form or dialog is one that is going to cause it's parent to stop running until its own process is finished (sorry if you knew that already).

I am pretty confident that that VBA msgbox is always modal. There's no way to put one on the screen and have the macro that created it continue running.

However, Userforms can be non-modal. You can set up a userform to look a lot like a msgbox, if you want.

UserForm1.Show vbModeless

There may be better solutions, but this is how I'd do it. Remeber that you'll have to figure out when you want the userform to go away and either hide or unload it as necessary.

 

[capparfrank]

Sorry for the long wait. Had a tough week over here


You can hide the userform and keep it around in memory. This is kind of nice if you find yourself wanting to build onto information that you've already put into the form once already. Just remember to unload it later on.

'from somewhere other than the userform
Userform1.Hide
 
'from the code launched from the form itself (like a button event)
Me.Hide

If you're done with it and you don't want invisible forms hogging up your resources, use unload.

'from somewhere other than the userform
Unload Userform1
 
'from the code launched from the form itself (like a button event)
Unload Me