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 to
enter free text. This section consists of eight rows. The idea is to
enter text into each row in succession so it has a paragraph-type
style. It works fine when the user hits the tab key before overwriting
the end of the row. When they forget, it cuts off the end of his/her
sentence.

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

Any help would be greatly appreciated.

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

 

[Tom Ogilvy]

Macros don't run while editing. You would need to put up a userform and
gather the information in a textbox, then put it into your eight rows or
reformat the users information after they completed entry in the worksheet
using the change event perhaps.