| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line break in cell
If I write text in a worsheet cell A1 Then:
[Alt + Enter] will insert Chr(10) - line break in cell A1 [Enter] activates the cell A2 It is possible to achive Chr(10) when I punch Enter. I try to use cell a text input field. rgds Jarle |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Line break in cell
What you are asking will not work. You have described the default behavior
and you can not get around that with macros (as macros will not execute while a cell is in edit mode). -- HTH... Jim Thomlinson "Jarle" wrote: If I write text in a worsheet cell A1 Then: [Alt + Enter] will insert Chr(10) - line break in cell A1 [Enter] activates the cell A2 It is possible to achive Chr(10) when I punch Enter. I try to use cell a text input field. rgds Jarle |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Line break in cell
Thanks. then I will use a shape.textbox to get what I need.
Jim Thomlinson skrev: What you are asking will not work. You have described the default behavior and you can not get around that with macros (as macros will not execute while a cell is in edit mode). -- HTH... Jim Thomlinson "Jarle" wrote: If I write text in a worsheet cell A1 Then: [Alt + Enter] will insert Chr(10) - line break in cell A1 [Enter] activates the cell A2 It is possible to achive Chr(10) when I punch Enter. I try to use cell a text input field. rgds Jarle |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| How do I enter a line break within a cell? | Excel Discussion (Misc queries) | |||
| Remove line break within cell | Excel Discussion (Misc queries) | |||
| line break in a cell | Excel Worksheet Functions | |||
| search for line break in cell | Excel Programming | |||
Linear Mode
