CLOSE MESSAGE BOX PROGRAMMATICALLY

[donstock]

Can a message box be closed programmatically? without any interaction with
the keyboard or mouse? I'm trying to display a message box for a given
amount of time then have it automatically close.
--

--
D.S.

[Dave Peterson]

Jim Rech posted this solution:

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

--

Dave Peterson
ec3...@msn.com

[Rockee052 <>]

Found this in google, hope it helps

If you have the Windows Scripting Host Obj model installed (WSHOM.OCX),
and
I believe it's part of Windows 98 among other things, you can run
this:

Sub SelfClosingMsgBox()
CreateObject("WScript.Shell").Popup "Hello", 2, "This closes itself

in 2 seconds"
End Sub

By, Jim Rech

Rockee

---
Message posted from http://www.ExcelForum.com/

[donstock]

Thanks, that works very well. I've also created a userform to look like a
message box, and use the OnTime method to unload the form after a given
interval.

D.S.

"Dave Peterson" <ec3...@msn.com> wrote in message
news:405CF73B...@msn.com...

[Ivan F Moala]

Have a look here with what you can do with Scripting & API's

http://www.xcelfiles.com/Excel03.html

Rockee052 <<Rockee05...@excelforum-nospam.com>> wrote in message news:<Rockee05...@excelforum-nospam.com>...

[Tom Ogilvy]

Ivan,
the link seems to be missing to download the workbook with the scripting
example. Just a heads up.

--
Regards,
Tom Ogilvy

"Ivan F Moala" <ivan...@xtra.co.nz> wrote in message
news:9e500a31.04032...@posting.google.com...

[Ivan F Moala]

Oh Jezz !! sorry ...... thanks Tom :-)
Appreciate the heads up.

Linked up now.

"Tom Ogilvy" <twog...@msn.com> wrote in message news:<105ri76...@news.supernews.com>...

[donstock]

Thanks Ivan & Tom,
I'll have to study on this a while.

D.S.