Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to have a textbox width fixed and have it´s height autosized?
I want the textbox height to change dynamicly at runtime. The number of lines (height) in the textbox would be determined by the amount of content, while the textbox length would remain constant. I´ve tried all kinds of solutions, but nothing seems to work for me. Thanks! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
AFAIK there's no such property -- Regards Frank Kabel Frankfurt, Germany V-Man wrote: Is it possible to have a textbox width fixed and have it´s height autosized? I want the textbox height to change dynamicly at runtime. The number of lines (height) in the textbox would be determined by the amount of content, while the textbox length would remain constant. I´ve tried all kinds of solutions, but nothing seems to work for me. Thanks! |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Have you tried tried to use a textbox from the Control Toolbox toolbar with the following properties: -Autosize=True -EnterKeyBehavior=True -Multiline=True Regards, Sebastien "V-Man" wrote: Is it possible to have a textbox width fixed and have it´s height autosized? I want the textbox height to change dynamicly at runtime. The number of lines (height) in the textbox would be determined by the amount of content, while the textbox length would remain constant. I´ve tried all kinds of solutions, but nothing seems to work for me. Thanks! |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Frank, Sebastienm:
I set MultiLine = True and wrote this VBA code - If TextBox3.TextLength 60 Then TextBox3.AutoSize = True Else TextBox3.AutoSize = False This keeps the horizontal length constant while adjusted the height according to the amount of data. Thanks! "sebastienm" wrote: Hi, Have you tried tried to use a textbox from the Control Toolbox toolbar with the following properties: -Autosize=True -EnterKeyBehavior=True -Multiline=True Regards, Sebastien "V-Man" wrote: Is it possible to have a textbox width fixed and have it´s height autosized? I want the textbox height to change dynamicly at runtime. The number of lines (height) in the textbox would be determined by the amount of content, while the textbox length would remain constant. I´ve tried all kinds of solutions, but nothing seems to work for me. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Rows - Height - AutoSize question | Excel Discussion (Misc queries) | |||
TextBox Autosize | Excel Discussion (Misc queries) | |||
AutoSize Command | Excel Discussion (Misc queries) | |||
Autosize Row Heights | Excel Discussion (Misc queries) | |||
comments AutoSize | Excel Programming |