msgbox

[Marcus]

could anyone please give me an example of the correct syntax for making a msgbox with a "yesnocancel" choice of buttons - every time i think i am there i get a message asking for me to add a "=" after my close bracket and i dont know what to put in there. please help!

Marcus

 

[Dan E]

Marcus,

Post what you have when you get the message.

VB is probably looking for you to assign the result to a variable so that it
can be used later on ie:

Answer = MsgBox("Do you want to ...?", vbYesNoCancel, "... Dialog")
If Answer = vbYes Then
'Code for Yes
ElseIf Answer = vbNo Then
'Code for No
Else
'Code for Cancel
End If

Dan E

could anyone please give me an example of the correct syntax for making a msgbox with a "yesnocancel" choice of buttons - every

time i think i am there i get a message asking for me to add a "=" after my close bracket and i dont know what to put in there.
please help!

 

[Harald Staff]

Hi Marcus

Sub test()
Select Case MsgBox("Yo da man?", _
vbYesNoCancel + vbQuestion, "Yo")
Case vbYes
MsgBox "You da man"
Case vbNo
MsgBox "OK..."
Case vbCancel
MsgBox "Sheesh"
End Select
End Sub

--
HTH. Best wishes Harald
Followup to newsgroup only please.

could anyone please give me an example of the correct syntax for making a msgbox with a

"yesnocancel" choice of buttons - every time i think i am there i get a message asking for
me to add a "=" after my close bracket and i dont know what to put in there. please help!

 

[Trevor Shuttleworth]

Marcus

msgbox "Test",vbYesNoCancel

Regards

Trevor

could anyone please give me an example of the correct syntax for making a

msgbox with a "yesnocancel" choice of buttons - every time i think i am
there i get a message asking for me to add a "=" after my close bracket and
i dont know what to put in there. please help!