Thread: msgbox
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default msgbox

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.

"Marcus" wrote in message
...
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