5 Ways of Adding newline in VBA (Carriage Return)

Adding a new line in VBA

In VBA, a newline can be added by using following:

• vbNewLine constant
• vbCrLf constant
• vbCr constant
• vbLf constant
• char(10) character

Let us see examples of these in the section below.

An example of vbNewLine constant for adding a new line

We have two string-type variables and assigned both texts after declaration.

In a MsgBox, we will concatenate both strings and add a newline by the vbNewLine constant. See the code and output below:

The code:

Output:

Adding new line in the Excel cell example

Writing in Excel cells is also simple. You just need to ensure the cell is enabled “Wrap Text” for which you want to insert new line.

You can see example of how to select “Wrap Text” in the above linked tutorial.

To demonstrate that, we will write three line text in the H8 cell as follows:

Code:

Output:

Using vbCrLf constant example

This is like pressing the Enter key. The vbCrLf constant stands for Carriage Return and Line feed.

The code:

Output:

Note: You might wonder why so many options for a line breaks in VBA? In order to understand the context, you might be interested in the history and reasons in a discussion in StackOverflow here.

Using vbCr constant example

The vbCr returns to a line beginning. It represents a carriage-return character.

You may also use the vbCr constant to add a line break between two or more sentences. See an example below:

Code:

Output:

vbLf example

The vbLf meant to go to the next line

It represents a linefeed character for print and display functions.

Example code

Output:

Using Chr(10) ASCII for newline

In VBA, the Chr(10) return a linefeed character. You may also use it to add newlines in strings.