Add Newline To VBA Or Visual Basic 6
Answer : Visual Basic has built-in constants for newlines: vbCr = Chr$(13) = CR (carriage-return character) - used by Mac OS and Apple II family vbLf = Chr$(10) = LF (line-feed character) - used by Linux and Mac OS X vbCrLf = Chr (13) & Chr (10) = CRLF (carriage-return followed by line-feed) - used by Windows vbNewLine = the same as vbCrLf Use this code between two words: & vbCrLf & Using this, the next word displays on the next line. There are actually two ways of doing this: st = "Line 1" + vbCrLf + "Line 2" st = "Line 1" + vbNewLine + "Line 2" These even work for message boxes (and all other places where strings are used).