Insert line break in wrapped cell via code

Question

Is it possible to insert line break in a wrapped cell through VBA code   similar to doing Alt-Enter when entering data manually   I have set the cell s wrap text property to True via VBA code  and I am inserting data into it also through VBA code

User · Answer

You could also use vbCrLf which corresponds to Chr 13   amp  Chr 10

User · Answer

Yes  The VBA equivalent of AltEnter is to use a linebreak character    ActiveCell Value    I am a    amp  Chr 10   amp   test    Note that this automatically sets WrapText to True    Proof   Sub test   Dim c As Range Set c   ActiveCell c WrapText   False MsgBox  Activcell WrapText is    amp  c WrapText c Value    I am a    amp  Chr 10   amp   test  MsgBox  Activcell WrapText is    amp  c WrapText End Sub

User · Answer

Just do Ctrl   Enter inside the text box

User · Answer

Yes there are two way to add a line feed    Use the existing function from VBA vbCrLf in the string you want to add a line feed  as such   Dim text As String  text    Hello   amp  vbCrLf  amp   World    Worksheets 1  Cells 1  1    text Use the Chr   function and pass the ASCII characters 13 and 10 in order to add a line feed  as shown bellow   Dim text As String  text    Hello   amp  Chr 13   amp  Chr 10   amp   World    Worksheets 1  Cells 1  1    text   In both cases  you will have the same output in cell  1 1  or A1

[vba] Insert line break in wrapped cell via code

Examples related to vba

Examples related to excel