View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Line Continuation issue

Oops..Use Vbcr Or VbLF for carriage return

Msg = MsgBox("You have "" "" PFs loaded in the Tally Sheet." & vbCrLf & _
"Have you completed "" ""PFs?", vbYesNo, "Completed PFs")

If this post helps click Yes
---------------
Jacob Skaria


"Bishop" wrote:

What am I doing wrong? Here is the line of code:

Msg = MsgBox("You have "" "" PFs loaded in the Tally Sheet. Have you
completed "" ""PFs?", vbYesNo, "Completed PFs")

But I want to use ' _' to continue the phrase on the next line but when I do
this:

Msg = MsgBox("You have "" "" PFs loaded in the Tally Sheet. _
Have you completed "" ""PFs?", vbYesNo, "Completed PFs")

I keep getting "Expected: list separator or )"