I have looked at this for 30 minutes and don't know what's wrong with this statement:
Code:
intResponse = MsgBox("Call Finnhub bool values" & vbCrLf & vbCrLf _
& "boolCallFinnhub: " & boolCallFinnhub & vbCrLf _
& "boolCallFinnhub2: " & boolCallFinnhub2 & vbCrLf _
& "boolCallFinnhub3: " & boolCallFinnhub3) & vbCrLf _
& "Yes: " & Chr$(9) & "Continue" & vbCrLf _
& "No: " & Chr$(9) & "Stop the program" , vbYesNo, "Continue or cancel?")
If the cursor is inside the statement and I move out I get "compile error. expected end of statement" with the comma before the vbYesNo highlighted. If I compile I get a generic syntax error.
This version without lines 2-4 works fine:
Code:
intResponse = MsgBox("Call Finnhub bool values" & vbCrLf & vbCrLf _
& "Yes: " & Chr$(9) & "Continue" & vbCrLf _
& "No: " & Chr$(9) & "Stop the program", vbYesNo, "Continue or cancel?")
I know this is something simple but I just don't see it.
Thanks.