You can use VBA. After the text is entered in the cell by your userform,
select that cell, then use .EntireRow.AutoFit to make Excel resize the row.
For example, if the text was in A10:

Range("A10").Select
Selection.EntireRow.AutoFit

If the text is longer than 1024 characters, Excel won't display all of it in
the cell. Also, the AutoFit method won't work if the cell is a merged cell.

Hope this helps,

Hutch

"Patrick C. Simonds" wrote:

I have a Userform which deposits some text into a cell. My problem is the it
the text is to long for the cell the text wraps but the row height does no
adjust to display all the text.