Sometimes the msgbox window opens behind other windows. Is there a way to tell it to open on top of all other open windows?
I think highlight would bring it to the front. I've used sendtoback many moons ago, wonder if there is a sendtofront?
Patience is like bread I say.... I ran out of that yesterday.
The trouble with .highlight would be that as soon as msgbox is run the code stops. It would not get to the .highlight line of code.
couple of ideas Kevin, use a wscript messagebox with a timeout or use a custom IE mini webpage.
how this will help kevin.
when things gets harder ,the harder gets going
If he's the one triggering the msgbox rather than his app.
Mark, Chikki, NoUse4aName,and others.
Has anyone used objShell.Popup?
Do you know if it is better at displaying in front of other windows than Msgbox?
Is wscript messagebox
the same as objShell.Popup?
Yes Kevin, here's an example of a popup with a timeout of 5 seconds
Set objShell = CreateObject("Wscript.Shell")
objShell.Popup "My Message", 5, "Popup Title"
set objShell = Nothing
I prefer to use a small IE page as it's more flexible, you can programmatically control it, capture user input etc.