#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Msg Box

how do I send Chr$(10) to a msgbox so I can have a
sentence in a msgbox on it's own line?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default Msg Box

one way (that works cross-platform):

MsgBox "Sentence 1." & vbNewLine & "Sentence 2."

In article ,
"joe user" wrote:

how do I send Chr$(10) to a msgbox so I can have a
sentence in a msgbox on it's own line?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Msg Box

or for just Chr$(10)

MsgBox "This is line 1" & vbLf & _
"This is line 2"


or

MsgBox "This is line 1" & chr$(10) & _
"This is line 2"


--
Regards,
Tom Ogilvy

"joe user" wrote in message
...
how do I send Chr$(10) to a msgbox so I can have a
sentence in a msgbox on it's own line?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"