VBA Insert data in line below within a textbox

Question

I am trying to figure out how to display newly entered text from one userform text box to another userform text box in a new line below. Pretty much I want it to a multiline input. Here is the code I am using so far:

Private Sub CommandButton1_Click()
UserForm1.TextBox1.Value = TextBox1.Value & vbNewLine
End Sub

PaichengWu · Accepted Answer · 2018-08-07 05:33:40Z

2

Try this

Private Sub CommandButton1_Click()
    UserForm1.TextBox1.Value = UserForm1.TextBox1.Value & vbNewLine & UserForm2.TextBox1.Value
End Sub

answered Aug 7, 2018 at 5:33

PaichengWu

2,6891 gold badge16 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mentos Over a year ago

you should mark his answer as the proper answer to you question now ;)

Jose Cortez Over a year ago

@PaichengWu Sorry to reopen this question, is there any way of making the text start a multi line after the first input has been submitted? You can see in my above screenshot that Sample Text 1 is all the way in the top, in your provided code "Sample Text 1" skips a line. Thanks again for all your help

PaichengWu Over a year ago

You can try to remove vbNewLIne and one & for my code.

Zorg Over a year ago

@PaichengWu, I think it should be added, that the MultiLine property of the corresponding TextBoX object must be set to True. I have forgotten this on my first try and wondered why this solution did not work. This is just an improvement of the given solution, which is right.

Collectives™ on Stack Overflow

VBA Insert data in line below within a textbox

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related