Copy from various text boxes to one text box - formating

[harveya915]

I have a UserForm that contains TextBoxes 1-3. I have a command button that when clicked will copy whatever is on TextBoxes 1-3 to TextBox4. The issue I have is that I want for the contents of boxes 1-3 are entered but each on it's own line. Right now I have for all text to come out consecutively. This is the code I have:

Private Sub CommandButton1_Click()
TextBox4.Value = TextBox1.Text & " " & "Received Agent Copy" & " " & TextBox2.Text & "Installment Amount" & TextBox3.Text
End Sub

So basically as an example I will get the following result (all in one consecutive line):
Box1 Contents Received Agent Copy Box2 Contents Installment Amount $100.00

The result I want is (separate lines):
Box1 Contents
Received Agent Copy Box2 Contents
Installment Amount $100.00

I'm a noob at this, I learn by searching.
Any help would be gladly appreciated.

 

[harveya915]

Did some searching and found this works. add vbNewLine where you want a new line to be inserted:

Private Sub CommandButton1_Click()
TextBox4.Value = TextBox1.Text & vbNewLine & "Received Agent Copy" & " " & "TextBox2.Text & vbNewLine & "Installment Amount" & " " & TextBox3.Text
End Sub

Hope this helps someone out.