second line
 

Hi,
Any possiblity in a cell after 10 text character it shoul
automatically move to the bottom line(as double line inside the cell)
like alt+Enter working . Secondly same question but after 10 tex
character the next one should go the bottom cell ( if iam working on A
after 10 character the 11 th should go to A2).
thanks in advance
nowfa

--
nowfa
-----------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...fo&userid=1000
View this thread: http://www.excelforum.com/showthread.php?threadid=39488

second line
 

Any possiblity...

None. Macros do not work when you're entering data in a cell. The best you
can do I think is to write a macro that modifies a cell after the entry is
completed.

--
Jim
"nowfal" wrote in
message ...
|
| Hi,
| Any possiblity in a cell after 10 text character it should
| automatically move to the bottom line(as double line inside the cell),
| like alt+Enter working . Secondly same question but after 10 text
| character the next one should go the bottom cell ( if iam working on A1
| after 10 character the 11 th should go to A2).
| thanks in advance
| nowfal
|
|
| --
| nowfal
| ------------------------------------------------------------------------
| nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
| View this thread: http://www.excelforum.com/showthread...hreadid=394888
|