View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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!"