Show VB msgbox in front of Excel worksheet.

[basepointdesignz]

Is there any way to show a VB msgbox in front of an Excel worksheet?

In my app I have a menu click to open an Excel worksheet, which then becomes the active window. What I want to do is display a msgbox (from my program) in front of the worksheet.

What I don't want to do is create the msgbox from within excel, as a macro, as the worksheet could be updated at any time in he future (If the worksheet is a new updated version, done by the user, he/she can replace the file in the necessary folder so the menu click will load the new one - the user will not know how to create macros in excel)

Any ideas?

Renegade

 

[dsi]

You could minimize Excel before showing the msgbox and maximize it afterwards.

 

[Strannik]

You can achieve that by specifying style of message box:

MsgBox "Push OK button",vbOKOnly + &H1000

&H1000 is constant which makes message box system modal dialog.

 

[basepointdesignz]

Thanks Strannik, Most helpful!!