ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Close Message box after 3 seconds (https://www.excelbanter.com/excel-programming/391751-close-message-box-after-3-seconds.html)

blackbox via OfficeKB.com

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1


NickHK

Close Message box after 3 seconds
 
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" <u20390@uwe wrote in message
news:740371ecbac2f@uwe...
Is there an easy way to make a mesage box close after 3 seconds rather

than
wait for user to click the "OK" button?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1




blackbox via OfficeKB.com

Close Message box after 3 seconds
 
Nick,

Thanks once agian!

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

NickHK

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


--
Message posted via http://www.officekb.com


Bob Phillips

Close Message box after 3 seconds
 
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" <u20390@uwe wrote in message
news:7404379cecb61@uwe...
Nick,

Thanks once agian!

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

NickHK

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


--
Message posted via http://www.officekb.com




blackbox via OfficeKB.com

Close Message box after 3 seconds
 
thanks for the tip, I'll keep an eye on it

Bob Phillips wrote:
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]
than
wait for user to click the "OK" button?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1


Peter T

Close Message box after 3 seconds
 
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

Bob Phillips wrote:
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.





blackbox via OfficeKB.com

Close Message box after 3 seconds
 
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

Peter T wrote:
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

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.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1


Bob Phillips

Close Message box after 3 seconds
 
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" <u20390@uwe wrote in message
news:74084a9dc3b6d@uwe...
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

Peter T wrote:
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

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.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1




blackbox via OfficeKB.com

Close Message box after 3 seconds
 
good point

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

Bob Phillips wrote:
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]
reported
problems, it fails to close, and I have seen it a few times myself.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1



All times are GMT +1. The time now is 06:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com