Thread: What is the Chr() code for Alt+Enter in a cell when entering text?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dennis Dennis is offline
external usenet poster
  
Posts: 4
Default 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
Reply With QuoteReply With Quote