View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Excel 2003 VBA string literal help location

"Walter Briscoe" wrote:
If You want that vbCrLf is your friend.
e.g. """Hello, " & vbCrLf & "World""".


IMHO, it is better to use vbNewline. That represents CRLF on non-Mac
platforms, and just CR on Mac platforms.

You can find this and other constants by putting "visual basic contants" in
the VBA help search field, then clicking on the link by that name, then
clicking on "miscellaneous contants".