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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - What is the Chr() code for Alt+Enter in a cell when entering text? (https://www.excelbanter.com/excel-discussion-misc-queries/100451-what-chr-code-alt-enter-cell-when-entering-text.html)

Dennis

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

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

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

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

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

Dennis

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

Thanks!

"Alan" wrote:

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

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

All times are GMT +1. The time now is 12:50 AM.