#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 304
Default MsgBox with timeout

I have the following code but I am missing the timeout function, help!

MsgBox "The update is now complete.", vbInformation, "NAME"

I just want to have it up for around 5-10 sec.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default MsgBox with timeout

Give this a whirl... Note Select Tools - References - Windows Script Host
Object Model

'requires reference to "Windows Script Host Object Model"
Public Sub MessageTest()
Dim SH As IWshRuntimeLibrary.WshShell
Dim Res As Long

Set SH = New IWshRuntimeLibrary.WshShell
Res = SH.Popup(Text:="Click Me", secondstowait:=2, _
Title:="Hello, World", Type:=vbOKOnly)

End Sub
--
HTH...

Jim Thomlinson


"pgarcia" wrote:

I have the following code but I am missing the timeout function, help!

MsgBox "The update is now complete.", vbInformation, "NAME"

I just want to have it up for around 5-10 sec.

Thanks

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
MsgBox bumper338 Excel Discussion (Misc queries) 1 December 22nd 06 11:32 PM
MsgBox CC Excel Discussion (Misc queries) 4 May 5th 06 05:45 PM
msgbox James Coughlan Excel Discussion (Misc queries) 3 May 3rd 06 01:57 PM
Timeout-Lockout capability Jim JBC Excel Discussion (Misc queries) 2 November 29th 05 07:15 PM
TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked ChefBoiRD Excel Worksheet Functions 3 September 20th 05 10:01 AM


All times are GMT +1. The time now is 11:42 PM.

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"