Wait for user response
 

Good evening Brisbane Rob

The code below shows how to get a MsgBox to await a yes/no input from
user. Technically, you only need line 2, the lines after that jus
demonstrate how to capture the user response.

Sub Test()
Response = MsgBox("The macro has now stopped. Select Yes or No"
vbYesNo)
If Response = vbYes Then
MsgBox "Selected : Yes"
Exit Sub
End If
MsgBox "Selected : No"
End Sub

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=46837