-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
I’m trying to operate a MsgBox with the VBYesNo extention?
- Thread starter razzandy
- Start date
Jay Petrulis
MrExcel MVP
- Joined
- Mar 17, 2002
- Messages
- 2,040
Hi,
Assign the result to a variable and test the variable.
<pre>Sub test()
Dim x
x = MsgBox("Do you want to say hi to Jay?", vbYesNo)
If x = vbYes Then
MsgBox "Hi to you, too!"
Else
MsgBox "OK, I'll let it slide this time."
End If
End Sub</pre>
Assign the result to a variable and test the variable.
<pre>Sub test()
Dim x
x = MsgBox("Do you want to say hi to Jay?", vbYesNo)
If x = vbYes Then
MsgBox "Hi to you, too!"
Else
MsgBox "OK, I'll let it slide this time."
End If
End Sub</pre>
Upvote
0
No variable is needed; by assiging the If statement directly to the Message Box statement. You can do this because the YesNo is a testable condition.
Like this:
If MsgBox("Do you want to say hi to Jay?", vbYesNo) = vbYes Then
MsgBox "Hi to you, too!"
Else
MsgBox "OK, I'll let it slide this time."
End If
Yours in EXCELent Frustraation
KniteMare
Computers are for gaming. Who invented this silly work stuff anyway?
Like this:
If MsgBox("Do you want to say hi to Jay?", vbYesNo) = vbYes Then
MsgBox "Hi to you, too!"
Else
MsgBox "OK, I'll let it slide this time."
End If
Yours in EXCELent Frustraation
KniteMare
Computers are for gaming. Who invented this silly work stuff anyway?
Upvote
0
