How do I get a msgbox to display in the foreground

[mcinernj]

I am running a VBA program. During this program I am doing a check of something...depending on the result I wish to present the user with a vbYesNo msgbox. This works but it shows in the Task Bar. I want this message to popup in front of them.

Any ideas?

Thanks,
Jeff

 

[PHV]

You may consider the AppActivate instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mcinernj]

The macro that I am running is Shipping.AVB and within it I have the following...

iResponse = MsgBox("Previous processing of " & sNewFileName & " was not completed...finish processing now?", vbYesNo)

This is the msgbox that shows in the task bar. How would I use AppActivate in this situation?

 

[PHV]

In which application is running the VBA code ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[DarkMain]

if MsgBox(YourPrompt, vbYesNo) = vbYes then <Do Yes stuff> else <Do No stuff>

DarkMain