LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 173
Default Auto Close Pop-up MsgBox

Dear Expert,

I am using Excel 2000 and want to have a pop-up msgbox closing in 2 or 3
seconds automatically.
I browsed the web and found following ....
But I tested .... It would not go away automatically in 2 seconds.
I have to press "OK" to kick this window out ....

Can you tell me how to fine-tune the VB scripts that make pop-up msgbox
really disappear in 3-second time please ?

Thanks

(Quote)
http://www.mvps.org/dmcritchie/excel/inputbox.htm

PopUp or Warning Box, short duration (#popup)
Jim Rech posted code (2000-09-20) to put a warning box up for two seconds
and then disappear.
Thanks to Dave Peterson for mentioning this in newsgroups
Sub SelfClosingMsgBox()
CreateObject("WScript.Shell").Popup "Hello", _
2, "This closes itself in 2 seconds"
End Sub
(End of Quote)
 
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
Msgbox Close with vba art Excel Programming 10 November 20th 08 01:23 PM
close msgbox Dan Excel Programming 4 July 30th 07 07:40 PM
Close msgbox ? Buddy Lee Excel Programming 3 November 22nd 05 04:14 PM
Close a MsgBox Taffy[_2_] Excel Programming 6 October 4th 04 09:39 PM
auto close while MsgBox is open Kevin Excel Programming 2 November 10th 03 12:36 AM


All times are GMT +1. The time now is 02:12 AM.

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"