Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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.




  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default 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

  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 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



  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically close a message box ed Excel Programming 3 October 31st 06 05:58 PM
Close userform after 2 seconds Kent Excel Programming 1 January 17th 06 02:17 PM
Warning message on file close Lambtwo Excel Worksheet Functions 1 October 25th 05 03:31 AM
Force a Message Box to close unanswered jennie Excel Programming 1 October 12th 05 10:23 AM
Close a message box Nigel Excel Programming 1 September 15th 05 12:49 AM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"