View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Heather O'Malley Heather O'Malley is offline
external usenet poster
 
Posts: 5
Default Message Box Macro

Hello,

Trying to create a message box -

Titled: check?
Asks the question: Have you saved and closed all other files?
Then gives you a yes, no, cancel choice.

Written the below code but keeps getting a message:

expected :=

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

Any ideas
Thanks
Heather