Macro to force text to rol to next cell

[d_low]

Guys/Gals:

A portion of a template I've created includes a section for users t
enter free text. This section consists of eight rows. The idea is t
enter text into each row in succession so it has a paragraph-typ
style. It works fine when the user hits the tab key before overwritin
the end of the row. When they forget, it cuts off the end of his/he
sentence.

What I'd like to do is write a macro that recognizes when the user i
near or has reached the end of the writable area of a particular ro
and automatically tabs to the next row. Maybe this could be done wit
some sort of cell width calculation. The code would then repeat itsel
until the user reached the end of the eighth row. In a perfect world
the code would function seamlessly with the user typing through al
eight rows without any extra keystrokes.

Any help would be greatly appreciated.

P.S. I've already tried the text wrap alternative and was no
satisfied with the look or results

 

[macropod]

Hi,

This would be very difficult for a macro to manage, because of the vagaries
of font sizes, word lengths, etc. You're probably better of either expanding
a single row to the required height, or merging the required number of rows
& wrapping the text. In either case, your users would then only need to
remember to press Alt=Enter if they need to insert a new para within the
cell.

Cheers

 

[d_low]

Thanks for the reply. That's exactly the problem I experienced with
limiting the number of characters per line. Capatilization, font
sizes, etc. affect the available (and thus usable) text space. That's
sort of why I wanted to gear the code towards the available row width.
The computer ought to be able to figure out what space it has and what
space it has left as one types. Once this is figured out, the
necessary code to send the cursor to the next row ought to be pretty
straight forward. Thanks again.