How do I tell what button in a message box the user clicked? 1

[PockyBum522]

I have a message box with yes and no for buttons, if the user clicks yes I want to run some code, and if he clicks no, I just want the message box to go away.

How?

Thanks!

 

[JohnYingling]

MsgBox is a function that returns an integer indicating which button was pressed. Put the cursor on MsgBox and press F1.

Constant Value Description
vbOK 1 OK
vbCancel 2 Cancel
vbAbort 3 Abort
vbRetry 4 Retry
vbIgnore 5 Ignore
vbYes 6 Yes
vbNo 7 No

For Help, Put the cursor on MsgBox and press F1.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)

 

[Goudarz]

As JohnYingling told above you can simply check msgbox return value. For example:

---------------
Dim ReturnAnswer As Integer

ReturnAnswer = MsgBox("Are you sure?", vbYesNo, "Confirm")

Select Case ReturnAnswer
Case vbYes: ' Answer is Yes
Case vbNo: ' Answer is No
Case vbOK: ' Answer is Ok
Case vbCancel: ' Answer is Cancel
End Select

 

[PockyBum522]

Thank you