View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Line Continuation issue

use

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

On 21 Maj, 14:37, 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 )"