What is the Chr() code for Alt+Enter in a cell when entering text?

D

Dennis

What is the Chr() code for the combination Alt+Enter in a cell when entering text?

Would this work in VBA?

"Line 1 " & Chr(xxx) & Chr(xxx) & "Line 2 "

Yields:

Line 1
Line 2
 
A

Alan

Try
"Line1" & vbcrlf & "Line2"
for one line space or
"Line1" & vbcrlf & vbcrlf & "Line2"
and so on,
Regards,
Alan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alt+Enter in cell with link to another cell 4
VBA inserting chr(10) or vbLf 5
VBA Multiple Line handling with Split() 1
VBA to edit a comment 3
Need help in printing vba code 0
MsgBox line break 1
Combining multiple cell values with "hard" carriage return separating each 3
how to format text in textbox? 1

Top