Carriage (Enter) instead of word wrap

Av8tordude

Well-known Member
Joined
Oct 13, 2007
Messages
743
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
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Av8tordude

Well-known Member
Joined
Oct 13, 2007
Messages
743
I research this, however, I would like to implement the line break while time in a textbox.

Can you elaborate please...thank you kindly
 
Last edited:

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Example for TextBox1

Code:
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
 

Watch MrExcel Video

Forum statistics

Threads
1,090,395
Messages
5,414,177
Members
403,517
Latest member
richardthevbanoob

This Week's Hot Topics

Top