ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is it possible to have a messageBox to display for 2 sec's and then Close AUTOMATICALLY ? (https://www.excelbanter.com/excel-programming/383917-possible-have-messagebox-display-2-secs-then-close-automatically.html)

Corey

Is it possible to have a messageBox to display for 2 sec's and then Close AUTOMATICALLY ?
 



Dave Peterson

Is it possible to have a messageBox to display for 2 sec's and thenClose AUTOMATICALLY ?
 
This seems to work under some versions of windows:

CreateObject("WScript.Shell").Popup "Hello", 2, _
"This closes itself in 2 seconds"

But it doesn't work in all versions of windows.



Corey wrote:

--

Dave Peterson

Corey

Is it possible to have a messageBox to display for 2 sec's and then Close AUTOMATICALLY ?
 
Dave,
Works Great on my system.
Is there a way to disable the [X]?
"Dave Peterson" wrote in message
...
This seems to work under some versions of windows:

CreateObject("WScript.Shell").Popup "Hello", 2, _
"This closes itself in 2 seconds"

But it doesn't work in all versions of windows.



Corey wrote:

--

Dave Peterson



Dave Peterson

Is it possible to have a messageBox to display for 2 sec's and thenClose AUTOMATICALLY ?
 
There have been posts on how to remove the X's on userforms--I don't know if it
work with this type of popup.

If you want to experiment, you can look at Stephen Bullen's FormFun.zip:
http://www.oaltd.co.uk/Excel/Default.htm

(I don't see too much benefit for the work it would take--but that's just my
opinion.)


Corey wrote:

Dave,
Works Great on my system.
Is there a way to disable the [X]?
"Dave Peterson" wrote in message
...
This seems to work under some versions of windows:

CreateObject("WScript.Shell").Popup "Hello", 2, _
"This closes itself in 2 seconds"

But it doesn't work in all versions of windows.

Corey wrote:

--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 04:55 PM.

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