How do I autofit row height to adjust to new text on Excel form?

[kbear34]

I'm trying to set up a form in Excel that will have text entered by other
people. There's a section of cells that I would like to set the row height
to autofit to wrapped text upon data entry. I've set the autofit row height
on a cell with wrapped text checked and tested it and the row height does not
change. Can anyone help with this, please?

 

[Gord Dibben]

Do you any merged cells in your form?

They will no respond to row autoheight.

Either get rid of them or you will need VBA code to deal with them.

For the code.................

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP