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?

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/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 08:19:02 -0800, kbear34
wrote:

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?