[RESOLVED] Multiline textbox

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

Code:

---

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

---

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! :D

Code:

---

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

---

or of course you could also use:

Code:

---

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

---

Cheers.
-EM

Or you could use

Code:

---

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

---