Message Boxes

How do I detect which button was pressed on a Message Box? Such as Yes, No, Cancel, etc...?

Dim RET As Integer
RET = MsgBox("HI", vbYesNoCancel)
If RET = vbYes Then Debug.Print "yes"
If RET = vbNo Then Debug.Print "no"
If RET = vbCancel Then Debug.Print "cancel"


David Paulson

Select Case MsgBox("Proceed?", vbYesNoCancel)
Case vbYes
'proceed with operation
cAse vbNo
'stop operation
Case vbCancel
'cancel operation
End Select




Same as the other answer but slightly more elegant layout.

HTH,
D.

-------------------------------------------------
Ex. Datis: Duncan Jones
Merrion Computing Ltd
http://www.merrioncomputing.com