View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cheerbubbles101 cheerbubbles101 is offline
external usenet poster
 
Posts: 2
Default Making row automatically expand as text is typed.

I am trying to figure out how to make the size (height) of the row
automatically expand as text is typed into the cell.

It is a comment box and I want to make the size automatically grow when the
users type more than the initial size of the cell. I don't want the users to
have to double click and resize the row themselves.

Any way to do this?