Message box macro

H

Heather O'Malley

Hello,

Trying to write code that gives me the follwing message box.

Title: Check?
Question:Have you saved and closed all other files?",
Option: yes,no,cancel

but it keeps saying expected:=

code is below:

MsgBox (prompt:="Have you saved and closed all other files?",
buttons:=vbYesNoCancel, title:="Check!")

Any ideas?
Thanks
Heather
 
F

FSt1

hi,
try this....
MsgBox "Have you saved and closed all other files?", _
vbYesNoCancel, "Check!"

regards
FSt1
 
A

Alan

Heather,

Just leave the brackets out ...

MsgBox prompt:="Have you saved and closed all other files?",
buttons:=vbYesNoCancel, title:="Check!"
 
Top