Function Error: Compile error: Expected: list separator or )

Hi all,

Using Excel 2013.

My code is returning the error, not sure why?:

Compile error: Expected: list separator or )

Error here:

lngMessageResponse = GetUserMessageResponse(strPrompt:="The selected worksheet does not contain any data." & vbCrLf & _
                                                                                           "Would you like to try a different worksheet?", _
                                                                         strTitle:="Missing Data Warning, _
                                                                         lngButtons:=vbYesNo)

Calling this Function:

Public Function GetUserMessageResponse(strPrompt As String, _
                                                             strTitle As String, _
                                                             lngButtons As Long) As Long

Thoughts?

thx
w

    lngMessageResponse = GetUserMessageResponse( _
                         strPrompt:="The selected worksheet does not contain any data." & vbLf & _
                                    "Would you like to try a different worksheet?", _
                         strTitle:="Missing Data Warning", _
                         lngButtons:=vbYesNo)

Thanks shg,

That works.

• Why vbLf as opposed to vbCrLf?
• Why is the "_" necessary at the beginning of the parameter list?

thx
w

1. Excel pretty much ignores carriage returns. For anything except writing output to a text file that requires the CR as part of the delimiter, line feed is sufficient.

2. Not necessary, just keeps the lines shorter, more readable, and therefore to me, more maintainable.

You were just missing a quote at the end of "... Warning"

Thanks shg,

Appreciate the explanations.
w

You're welcome.