Line break in cell

[Jarle]

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

 

[Jim Thomlinson]

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).

 

[Jarle]

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

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