Resizing row height to dynamically fit height of text box

[Guest]

Is there a way to link the height of a text box to the height of a row so
that as you type text into the text box and the text box's height increases,
the row height will also increase?

I know That by setting the "Move and size with cells" option you can make
the TEXT BOX height increase as the ROW height increases, but I'm looking to
do the opposite (i.e. make the ROW height increase as the TEXT BOX height
increases).

 

[Guest]

Not too complicate things too much, but I was also hoping to do this within a
protected sheet.