Hi - I'm trying to have multiple lines of text appear in my message box but
can't figure out how to do this. Basically, I'd like my Msgbox to display,
for example, the following text:

"Hi! Thanks for using this spreadsheet.
My name is Rob and I hope you find this useful.
Please contact me if you have any problems!"

Basically, I literally want to have this on three lines. Currently I have
the following code but can't figure out how to get this message on three
lines. I've tried to insert chr(13), hoping that would move the desired text
to the next line, but I haven't been able to figure out the proper syntax.
Thx!

MsgBox "Hi! Thanks for using this spreadsheet. My name is Rob and I hope
you find this useful. Please contact me if you have any problems!"

MsgBox "Hi! Thanks for using this spreadsheet." & VbNewLine & _
"My name is Rob and I hope you find this useful." & VbNewLine & _
"Please contact me if you have any problems!"

HTH. Best wishes Harald

"Linking to specific cells in pivot table"
crosoft.com skrev i
melding ...
Hi - I'm trying to have multiple lines of text appear in my message box
but
can't figure out how to do this. Basically, I'd like my Msgbox to
display,
for example, the following text:

"Hi! Thanks for using this spreadsheet.
My name is Rob and I hope you find this useful.
Please contact me if you have any problems!"

Basically, I literally want to have this on three lines. Currently I have
the following code but can't figure out how to get this message on three
lines. I've tried to insert chr(13), hoping that would move the desired
text
to the next line, but I haven't been able to figure out the proper syntax.
Thx!

MsgBox "Hi! Thanks for using this spreadsheet. My name is Rob and I hope
you find this useful. Please contact me if you have any problems!"

I find CHR(13) works beautifully too -- I have never seen it fail to drop a
line. Has anyone seen it not work?


"Harald Staff" wrote in message
...
MsgBox "Hi! Thanks for using this spreadsheet." & VbNewLine & _
"My name is Rob and I hope you find this useful." & VbNewLine & _
"Please contact me if you have any problems!"

HTH. Best wishes Harald

"Linking to specific cells in pivot table"
crosoft.com skrev i
melding ...
Hi - I'm trying to have multiple lines of text appear in my message box
but
can't figure out how to do this. Basically, I'd like my Msgbox to
display,
for example, the following text:

"Hi! Thanks for using this spreadsheet.
My name is Rob and I hope you find this useful.
Please contact me if you have any problems!"

Basically, I literally want to have this on three lines. Currently I
have
the following code but can't figure out how to get this message on three
lines. I've tried to insert chr(13), hoping that would move the desired
text
to the next line, but I haven't been able to figure out the proper
syntax.
Thx!

MsgBox "Hi! Thanks for using this spreadsheet. My name is Rob and I
hope
you find this useful. Please contact me if you have any problems!"

William,

This gives a pretty good overview of all your options:
http://support.microsoft.com/?kbid=211774

Thanks Nick ...
The list there says

vbNewLine A platform-specific new line character, either [Chr(13) +
Chr(10)] or [Chr(13)]

so ... are there platforms where the former is required? I have never used
chr(10).


"Nick Hebb" wrote in message
oups.com...
William,

This gives a pretty good overview of all your options:
http://support.microsoft.com/?kbid=211774

On Windows VbCrLf is equivalent to VbNewLine, so every time that you've
used either one you've implicitly used chr(10) - line feed.

I imagine that the other systems that use only chr(13) - carraige
return - would primarily be Macs.

This is slightly off topic, but if you ever want to wrap text in a
cell, use VbLf to pick the exact position where you want the line
break. Using VbNewLine or VbCrLf will insert the line break but also
display a little black square. I only mention it because I wasted
longer than I want to admit trying to figure that out one day.