Add newline to VBA or Visual Basic 6

Question

I want to concatenate two strings with a linebreak between them.

st = "Line 1" + newline + "Line2"

How do I add a newline to VBA or Visual Basic 6?

You'll want to do this: [`st = "Line 1" + vbCrLf + "Line2"`](http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.constants.vbcrlf%28v=vs.110%29.aspx) — admdrew, Nov 21 '14 at 17:54
Probably because this is very easy to search for. I would argue this Q/A isn't really helpful, as it's well-known/well-documented information. — admdrew, Nov 21 '14 at 17:57
Yes a simple Google search for "how do i create a new line in a string vba" returns the answers. Especially given you answered your own question as a "I'm going to throw this out there as a good searchable answer because it doesn't exist" but in reality it does. It does exist. — Chrismas007, Nov 21 '14 at 18:00
4700-20K+ google hits for this on this site alone (depending on how you word it). I am quite certain MSDN would have the answer as well. — Ňɏssa Pøngjǣrdenlarp, Nov 21 '14 at 18:00
http://blog.stackoverflow.com/2011/07/its-ok-to-ask-and-answer-your-own-questions/ — Gerhard Powell, Apr 19 '16 at 16:21
I disagree with the "asked and answered" crowd. I come to stack overflow not only to find answers, but to find out the best answers. In this case, it seems that there are no escape sequences in VBA. Good to know. While this was an overly simple example ;), there are plenty where I go to stack overflow to look first. Hopefully my +1 keeps you excited about generating answers for people like myself. — Gerard ONeill, Dec 14 '16 at 21:10

score 99 · Accepted Answer · edited Aug 14 '20 at 16:42

99

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

edited Aug 14 '20 at 16:42

Peter Mortensen

answered Nov 21 '14 at 17:54

Gerhard Powell

6

While this is the correct answer, this question has been asked and answered many times. – Chrismas007 Nov 21 '14 at 18:00
8

@voters instead of downvoting a correct answer, try close voting the question if you think it's a duplicate. – Blackhawk Nov 21 '14 at 22:51
Doesn't VBA use chr not char? – Usagi Aug 01 '18 at 18:53
@Usagi Updated it to match VBA/VB6. Thank you for your input! – Gerhard Powell Aug 01 '18 at 20:15
For a complete documentation, if you want a line jump, equal to Shift + Enter in Word, use Chr(11) – djibe Jan 28 '20 at 10:30

score 23 · Answer 2 · edited Aug 14 '20 at 16:43

23

Use this code between two words:

& vbCrLf &

Using this, the next word displays on the next line.

edited Aug 14 '20 at 16:43

Peter Mortensen

answered Jan 10 '16 at 04:22

Gajanan Chitare

1

`vbNewLine` is preferred because it will select the correct line terminator. – HackSlash Jan 28 '19 at 21:47

score 3 · Answer 3 · edited Aug 14 '20 at 16:50

3

There are actually two ways of doing this:

These even work for message boxes (and all other places where strings are used).

edited Aug 14 '20 at 16:50

Peter Mortensen

answered Nov 15 '18 at 11:22

AryanSonwatikar

3 Answers3