Automatic resuming after Message Box ?

[aca]

Once a MsgBox has popped up,
is there some code that will make it disappear after a pause of, say, 3 seconds (and execution of the macro resume and proceed),
without the user having to press ENTER or ESC?

I searched the Forum and found suggestions like this one:
Code:
Application.Wait (Now + TimeValue("0:00:3"))but they don’t seem to work after MsgBox:

Much obliged for any help
ACA

[JBeaucaire]

Once a MsgBox has popped up, is there some code that will make it disappear after a pause of, say, 3 seconds ....

EDIT: I am sorely wrong on this one....as Andy has pointed to some very useful examples!

[Andy Pope]

If it's your message box then maybe
http://www.excelforum.com/excel-prog...ssage-box.html

[aca]

Thank you, JBocaire, for that reminder.
However, because of Andy Pope's hopeful suggestion (I thank you also, Andy), I can add that
yes: the Message Box is of my own making (to notify that the data in the worksheet just opened hasn't been updated).
So, any possibilities, Andy?
aca

[mohd9876]

you can use the Popup method from the Wscript.Shell library and specify a period of time after which the box will be hidden

Please Login or Register  to view this content.

see this

[Andy Pope]

Did you check the link I posted?

[aca]

Query solved.

Gosh, mhd, you're knowledgeable!
That's the answer; it works perfectly. Many thanks.

And sorry, Andy, I hadn't noticed your link. That also works all right.

I added to your reputation; both.
ACA

[aca]

Besides Mohd's and Andy's solutions above, I've subsequently thought of another way around this problem:
Instead of a MesgBox I can use a UserForm with only a TextBox in it.
A UserForm does disappear after a pause (provided its ‘ShowModal’ property is set to ‘False’);
so, for instance, with this code for 2 seconds:

Please Login or Register  to view this content.

Besides, the TextBox in the form lets me use the colors and font sizes I want.
ACA

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.