In Excel itself, use Alt+Enter.
In VBA use Chr(10) like: Cells(1, 1) = "AA" & Chr(10) & "BB"

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Merlin" wrote in message
...
How can you program the "ENTER" key to enter a new line in an Excel Cell?