[RESOLVED] Multiline textbox

[Fonty]

Suppose you populate two cells:

Range("A1").text = "This is the first line"
Range("A2").text = "This is the second line"

Then you have a textbox and you set the multiline property to true. How can you fill the textbox so that you see both cells in two separate lines like:

This is the first line
This is the second line

[Siddharth Rout]

Textbox1.Text = Range("A1").Value & Chr(10) & Range("A2").Value

[emartinho]

Hi,
Not to tread on any toes koolsid, but that will not work. A new line in Windows needs both CR and LF and your code only puts LF.

Using vbCrLf solves all!

Textbox1.Text = Range("A1").Value & vbCrLf & Range("A2").Value

or of course you could also use:

Textbox1.Text = Range("A1").Value & Chr(13) & Chr(10) & Range("A2").Value

Cheers.
-EM

[Hack]

Or you could use

TextBox1.Text = Range("A1").Value & vbNewLine & Range("A2").Value