The lines with MsgBox in Bob's code are just placeholders. You'll want to
replace them with what you want to happen in each situation.



CC wrote:

Now I have the message "TIME OUT " That need to Click OO

"Bob Phillips" wrote:

Dim cTime As Long
Dim WSH As Object

Set WSH = CreateObject("WScript.Shell")
cTime = 10 ' 10 secs
Select Case WSH.Popup("Open an Excel file?!", cTime, "Question",
vbOKCancel)
Case vbOK
MsgBox "You clicked OK"
Case vbCancel
MsgBox "You clicked Cancel"
Case -1
MsgBox "Timed out"
Case Else
End Select


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"CC" wrote in message
...
I have a macro that run every 30 minute and at the end a msgBox popup show
up
to say "I'll be back in Half hour BUT show up with a button "OK" and I
need press that button in order to run a macro again .

MY QUESTION IS THIS : Is it possible a msgbox popup and disappear , let
say 5 seconds later without human intervention ???

Thank in advance
Cc




--

Dave Peterson