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

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

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