MsgBox

[Sasa]

Im trying to make MsgBox answer condition but it doesnt
work.

Here is the code:

MsgBox "Is this correct?", vbQuestion = vbYesNo
If MsgBox = vbNo Then Exit Sub Else ...

It keeps telling me that "Argument is not optional" and
highlight the second line "MsgBox" word.
I dont understand. I have this code from VBA help. It must
work.

Help is apreciated.

Sasa

 

[Lin Joyner]

You need to store the return value from calling the message box in a
variable and then test that variable on the second line.

Something like the following (untested) code:
Dim response As Integer
response = MsgBox("Correct?", vbYesNo)
If response = vbNo Then
Exit Sub
Else
'do something
End If

Hope this helps!
Lin

 

[JGM]

Hi Sasa,

Look at the help example again... you missed something important,

your code should be something like:

_______________________________________
Dim myMsgBox As Variant

myMsgBox = MsgBox("Is this correct?", vbYesNo)
If myMsgBox = vbNo Then Exit Sub
_______________________________________

You have to declare a variable and assign the MsgBox to that variable. Then
the variable will return the user's interaction with the box...

HTH
Cheers!

 

[Sasa]

Thank you all.

Sasa