View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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