Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You asked this 50 minutes ago and received two valid solutions.
|
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Heather,
Just leave the brackets out ... MsgBox prompt:="Have you saved and closed all other files?", buttons:=vbYesNoCancel, title:="Check!" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row Expansion | Excel Worksheet Functions | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro message box | Excel Discussion (Misc queries) | |||
Macro - message box if find nothing | Excel Discussion (Misc queries) |