how do I put a newline in a vba msgbox string
In Zoho sheets on the web, I inserted a button and assigned a VBA macro to it. This macro has a msgbox(string) in it. In making that string, I'd like to add newlines. I tried:
- msgbox("one" & vbNewLine & "two")
- ' and
- msgbox("one" & vbCrLf & "two")
Both those gave the error:
- Encountered error at line 63 : Invalid arguments: Object doesn't support this property or method
Either of these line of code:
- strdbg = vbNewLine
- strdbg = vbCrLf
gave the error:
- Encountered error at line 62 : Invalid arguments: Object variable or With block variable not set
This configuration:
- msgbox("one" & Chr(13) & Chr(10) & "two")
does not yield an error, but does not display a newline in the msgbox display either.
Is there a way to put a newline in a msgbox?