Close Message box after 3 seconds

[blackbox via OfficeKB.com]

Is there an easy way to make a mesage box close after 3 seconds rather than
wait for user to click the "OK" button?

 

[NickHK]

You can use the MsgBox exposed through Windows Script, which has an optional
timeout argument.
http://www.xcelfiles.com/Excel03.html

NickHK

 

[blackbox via OfficeKB.com]

Nick,

Thanks once agian!

You can use the MsgBox exposed through Windows Script, which has an optional
timeout argument.
http://www.xcelfiles.com/Excel03.html

NickHK

 

[Bob Phillips]

Note that this method is notoriously unreliable. Many people have reported
problems, it fails to close, and I have seen it a few times myself.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[blackbox via OfficeKB.com]

thanks for the tip, I'll keep an eye on it

Note that this method is notoriously unreliable. Many people have reported
problems, it fails to close, and I have seen it a few times myself.

Nick,

[quoted text clipped - 10 lines]

 

[Peter T]

thanks for the tip, I'll keep an eye on it

It might always work for you, but there's at least a 50/50 chance it won't
for your users

Regards,
Peter T

 

[blackbox via OfficeKB.com]

as long as they can still hit the "OK" button to close it, it's not that big
of a deal

but no problems so far

thanks again

 

[Bob Phillips]

By that philosophy, why bother, just use MsgBox.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[blackbox via OfficeKB.com]

good point

If i hear of any problems with it I may change it back to a regular message
box

By that philosophy, why bother, just use MsgBox.

as long as they can still hit the "OK" button to close it, it's not that
big

[quoted text clipped - 15 lines]