message without stopping execution?
Is the problem that you don't want the code interrupted, or that you want
the MsgBox timed, and not depend upon a user responding. If the latter, use
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
"Stefi" wrote in message
...
Hi All,
Is there any method to display a message during a lengthy process to
inform
the user on progress of the process without stopping execution as MsgBox
always does?
Stefi
|