ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   AutoSizing TextBox (https://www.excelbanter.com/excel-programming/282291-autosizing-textbox.html)

Price

AutoSizing TextBox
 
I desire to create a collection of merged cells (say 5 cells), or a
textbox, which will wordwrap and grow (or autosize) so that all text
is seen on the sheet.

Can anyone assist with instructions on this?

Tom Ogilvy

AutoSizing TextBox
 
right click on your text box and under format textbox, on the alignment tab,
you can set it to autosize by checking automatic size. This is a textbox
from the Drawing Toolbar.

--
Regards,
Tom Ogilvy



"Price" wrote in message
om...
I desire to create a collection of merged cells (say 5 cells), or a
textbox, which will wordwrap and grow (or autosize) so that all text
is seen on the sheet.

Can anyone assist with instructions on this?





All times are GMT +1. The time now is 09:29 AM.

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