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 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