ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Text control won't expand (https://www.excelbanter.com/new-users-excel/262277-text-control-wont-expand.html)

LINDA

Text control won't expand
 
I have text controls that are word wrapped and a 250 size. Can enter the
text, and it does wrap, but the size of the control won't expand to see all
the text that is entered. Some people will enter 3 words, some a paragraph,
so the text control needs to expand the cell instead of having to lock the
cell size to the largest needed. Any ideas how to overcome?

ozgrid.com

Text control won't expand
 
Set the AutoSize property to True or add a vertical scrollbar.


--
Regards
Dave Hawley
www.ozgrid.com
"Linda" wrote in message
...
I have text controls that are word wrapped and a 250 size. Can enter the
text, and it does wrap, but the size of the control won't expand to see
all
the text that is entered. Some people will enter 3 words, some a
paragraph,
so the text control needs to expand the cell instead of having to lock the
cell size to the largest needed. Any ideas how to overcome?




All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com