Message box macro
 

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

Message box macro
 

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

regards
FSt1

"Heather O'Malley" wrote:

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

Message box macro
 

You asked this 50 minutes ago and received two valid solutions.

Message box macro
 

Heather,

Just leave the brackets out ...

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