Re: MsgBox

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <CC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5620FED0-B6C6-4EF1-9383-F3964BBE9A11@xxxxxxxxxxxxxxxx
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
.

Quantcast