Dear Bishop

A small suggestion. When you have bigger text to be displayed use a variable
to build the message before display..something like..the below

Dim intCount As Integer
Dim strMsg As String

strMsg = "You have " & intCount & " PFs loaded in the Tally Sheet."
strMsg = strMsg & vbCrLf & vbCrLf & " Have you completed " & intCount & "
PFs?"

If MsgBox(strMsg, vbYesNo + vbDefaultButton2, " Completed PFs") < vbYes _
Then Exit Sub


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


"Jacob Skaria" wrote:

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