MsgBox Question

[FranS37]

I use this message box to prompt the user:

MsgBox "Save this PO", vbYesNo, "Purchase Order"
If vbYesNo = No Then.....

The value of vbYesNo, regardless of whether I click Yes or No, is 4!

Can anybody help?

Thanks, Fran

 

[jrbarnett]

Fran,

You need to use MsgBox in a function call, thus:

If MsgBox ("Save this PO", vbYesNo, "Purchase Order&quot = vbNo Then
' stick some code here
End If

If you need to check the result later on, you can assign the result of the MsgBox function to an integer variable and refer to it later on. There are many variables in addition to vbNo, representing different buttons, each of which has an integer value.

John

 

[PaulBricker]

Try this
If (MsgBox "Save this PO?",vbYesNo)=vbNo Then



Paul

 

[FranS37]

Thank you, both worked!

Fran