How do I auto adjust row height on merged columns w/wrapped text?

[Guest]

I am developing a form for capital requisitions that requires detail to be
entered regarding the project. To make it simple for the user, I would like
the rows to auto adjust their height as the person types their text. This
row of data is merged across several columns.
Text box is out of the question as is asking them to watch their margins if
they just type across a row that isn't wrapped. This is a KISS (keep it
simple, stupid) project.
I appreciate anyone's help!!!!

 

[Guest]

Why are you using Excel? Use Word, and then click insert field--Fillin.
(note you will need to scrowl down to use this feature. The outcome is you
will get a text box that allows any text entry to be added to the document,
Use it as may times in a document as necessary to give the flexability of
fill in information, yet maintain structure of the document.
Hope this is helpful Bill

 

[Guest]

There are many drop down boxes and formulas in the rest of the form. It
would be difficult to incorporate all of them into Word.
I found the answer to the problem; it is VB code that is applied to the
worksheet. Now the text wraps and expands as one types.