Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically close a message box | Excel Programming | |||
Close userform after 2 seconds | Excel Programming | |||
Warning message on file close | Excel Worksheet Functions | |||
Force a Message Box to close unanswered | Excel Programming | |||
Close a message box | Excel Programming |