Program "Enter" Key

[Guest]

How can you program the "ENTER" key to enter a new line in an Excel Cell?

 

[Guest]

Try this:

While editing a cell....hold down the [alt] key and press [enter].

That will insert a new line in the cell.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

How can you program the "ENTER" key to enter a new line in an Excel Cell?

Hold down the Alt key when you press enter for a new line when editing the
cell(if that's what you were asking). No idea how you'd be able to this just
by pressing Enter though. Stick the Alt key down with glue maybe?

 

[Chip Pearson]

You can't. Just use ALT+ENTER instead.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Daniel CHEN]

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
=================================