ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Auto Adjusting Text Boxes? (https://www.excelbanter.com/new-users-excel/39781-auto-adjusting-text-boxes.html)

Jae

Auto Adjusting Text Boxes?
 
Is there a way to have text boxes expand, if necessary, to account for large
amounts of text? I'm thinking more length wise vs. width.

Thanks,

Jae

Tushar Mehta

Depending on what kind of textbox you have it may have a 'auto size'
option. If you add one from the Drawing toolbar, double-click the
object then the Alignment tab.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Is there a way to have text boxes expand, if necessary, to account for large
amounts of text? I'm thinking more length wise vs. width.

Thanks,

Jae



All times are GMT +1. The time now is 12:14 AM.

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