Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Msgbox Close with vba | Excel Programming | |||
close msgbox | Excel Programming | |||
Close msgbox ? | Excel Programming | |||
Close a MsgBox | Excel Programming | |||
auto close while MsgBox is open | Excel Programming |