MsgBox with Yes/No

[VBAmateur]

Fro some reason this code will not work where I have it. it is just a message box with yesno and when yes is no is clicked I want it to exit the sub. Am i missing something:

Dim iAnswer As Integer

MsgBox "Did You Save Your New Changes?", vbYesNo + vbInformation, "Close Inventory History Page"
If iAnswer = vbno Then
Cancel = True
Exit Sub
End If

[_eclipsed_]

Try this:

Dim iAnswer As Integer 

iAnswer= MsgBox "Did You Save Your New Changes?", vbYesNo + vbInformation, "Close Inventory History Page" 
If iAnswer = vbno Then 
Cancel = True 
Exit Sub 
End If

[Chris]

Why we need the iAnswer?

If MsgBox("Did You Save Your New Changes?", vbYesNo + vbInformation, "Close Inventory History Page") = vbNo Then
Cancel = True
Exit Sub
End If

Try this:

Dim iAnswer As Integer 

iAnswer= MsgBox "Did You Save Your New Changes?", vbYesNo + vbInformation, "Close Inventory History Page" 
If iAnswer = vbno Then 
Cancel = True 
Exit Sub 
End If

[karunakaran]

Hai VBAmateur,
You are using msgbox statement it will not return
any values.

what chris is saying is correct.Chris is using a msgbox
function.From that only you can expect a value ,to react
accordingly.


Dim response 'declare a variable to hold the value.

response=msgbox(-------------)
if response=vbyes then
--do something

else

cancel=true

end if



thanks
karun