Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code Execution Message | Excel Discussion (Misc queries) | |||
Code Execution has been interrupted message | Excel Programming | |||
Message Box Execution | Excel Programming | |||
Stopping the Update Links Message | Excel Programming | |||
Stopping "Link Worksheets?" message box (using automation) | Excel Programming |