How do I add a line break inside a cell using Excel VBA?

Use Chr(10) or vbLf to insert a line break in cell content: Cells(1,1).Value = 'Line 1' & Chr(10) & 'Line 2'. Ensure Wrap Text is on for the cell to display the break.

What is the difference between vbCrLf, vbLf, and Chr(10) in VBA?

vbCrLf inserts both a carriage return and line feed (Chr(13)+Chr(10)), which is standard for Windows text. In Excel cells, Chr(10) (line feed only) is sufficient for a visible line break.

How do I add a line break in an Outlook email body written from Excel VBA?

Use vbCrLf for email body text in VBA: body = 'Dear ' & name & vbCrLf & vbCrLf & 'Please find attached...' - this creates proper paragraph spacing in email clients.

Carriage Returns & Line Breaks in Excel VBA

So, you might be working on a code that returns lines or paragraphs of text into a cell or text box in Microsoft Excel, and you want to make sure that this text is presently in an orderly, parapraph-like fashion. This is where the carriage return + line feed code comes in handy. This code will space out the text by creating line breaks wherever it is inserted, so that a new paragraph is automatically formed. It has a similar effect to using Alt+Enter in regular Microsoft Excel when entering data into sheet cells. This code is vbCrLf (or Chr10). This is basically how it works: Code 1:

Cells(1,3).value = "Hi " & "My name is Excel User"

Result:

Code 2:

Cells(1,3).value = "Hi " & Chr(10) & "My name is Excel User"

Cells(1,3).value = "Hi " & vbCrLf & "My name is Excel User"

Result:

Add Line Breaks in Excel VBA: vbCrLf, Chr(10) and Chr(13) Explained

Frequently Asked Questions