View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default 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