Multiple lines desired in Msgbox
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!"
|