Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 363
Default Is it possible to have a messageBox to display for 2 sec's and then Close AUTOMATICALLY ?



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


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
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 Book1 Dave486 Excel Discussion (Misc queries) 0 April 26th 08 11:47 PM
Automatically Close Workbook ed Excel Programming 1 November 5th 06 01:49 PM
Automatically close a message box ed Excel Programming 3 October 31st 06 05:58 PM
close without saving automatically goofy11 Excel Programming 2 September 14th 05 02:29 AM
Automatically Close Excel Greg[_15_] Excel Programming 1 August 18th 04 02:46 PM


All times are GMT +1. The time now is 06:39 AM.

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

About Us

"It's about Microsoft Excel"