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

[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

 

[Alan]

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

 

[Dennis]

Thanks!

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