Line break in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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).
 
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 said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 stripping out line feeds 3
Userform textbox string to header causes unwanted double spacing 4
finding where text wraps in a textbox 4
Help with loop 1
Display entire number in cell 3
Extracting a number from a multiline-entry 9
How to Autofit column when cells have Wrapped Text? 2
Excel to text file 4

Back
Top