ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Text box in User Form resizing upon data entry (https://www.excelbanter.com/excel-programming/377016-text-box-user-form-resizing-upon-data-entry.html)

Barb Reinhardt

Text box in User Form resizing upon data entry
 
I've created a text box in a user form and when I make an entry it appears to
resize the text box. What do I need to change so that it doesn't resize?

Thanks

Barb Reinhardt

Text box in User Form resizing upon data entry
 
Found it. Needed to adjust the IntegralHeight property of the text box.

"Barb Reinhardt" wrote:

I've created a text box in a user form and when I make an entry it appears to
resize the text box. What do I need to change so that it doesn't resize?

Thanks



All times are GMT +1. The time now is 07:27 AM.

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