#1   Report Post  
Posted to microsoft.public.excel.misc
ESR ESR is offline
external usenet poster
 
Posts: 1
Default TextBox Autosize

All - I am inserting a textbox via toolbox control selection that I would
like to Autosize only vertically. The horizontal width I have set to match
my form. The problem is when I set these paramaters through the properties
control of the Textbox then close properties and deselect the textbox (with
no text entered yet), it shrinks back to 1x1 (col,row) and expands only
vertically when text is entered (1 col,multi rows). How can I set the width
property and make it stay PRIOR to text being entered. Below are the
properties I have set in the Textbox
AutoSize (True)
MultiLine (True)
WordWrap (True)
Width (500) Which I dragged to match my form

Thanks ESR

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate Textbox value based on another textbox value Tdungate Excel Discussion (Misc queries) 0 February 12th 09 07:03 PM
Autosize merged cells Teri Excel Discussion (Misc queries) 7 March 6th 08 05:59 PM
How to autosize the cell when copying hon123456 Excel Discussion (Misc queries) 3 June 24th 06 05:47 AM
AutoSize Command CWillis Excel Discussion (Misc queries) 2 June 1st 06 03:22 PM
Autosize Row Heights Andibevan Excel Discussion (Misc queries) 6 May 11th 05 01:45 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"