Automatically adjust rowheight?

[h0ps]

Hi!

I have a cell in my excel sheet which value is determined by a textbox in an userform. Ufortunately the input can be so large that it can't be covered by one A4 paper. Can I somehow automatically adjust the rowheight and wrap the text, so the text input stays on the first page?

Hope it made sense... thx in advance

[TMS]

In Page Layout, you can set it to fit to one page high by one page wide. And, in Format Cells, Alignment, you can set the text to "shrink to fit".

You can also set the row height to Autofit.

Between these settings, you may be able to achieve what you wish.


Regards, TMS