Carriage (Enter) instead of word wrap

[Av8tordude]

Can someone as assist with a code that will enter a carriage (Enter) whenever the multi-line textbox wraps the string to the next line. I know the multi-line textbox will do this for me, but I need this to enter it a cell to indicate to separate line.

Thanks for you

 

[James006]

Hi,

Have you tried CHAR(10) ...?

Hope this will help

 

[Av8tordude]

I research this, however, I would like to implement the line break while time in a textbox.

Can you elaborate please...thank you kindly

 

[James006]

Example for TextBox1

Private Sub UserForm_Initialize()
' Make sure to set TextBox1 Multiline property to True
TextBox1.Value = Range("A1") & Chr(10) & Range("A2")
End Sub

Hope this will help