Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Autosize TextBox Height

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Autosize TextBox Height

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 694
Default Autosize TextBox Height

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Autosize TextBox Height

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
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
Excel 2007 - Rows - Height - AutoSize question John Excel Discussion (Misc queries) 1 October 22nd 11 06:33 PM
TextBox Autosize ESR Excel Discussion (Misc queries) 0 March 13th 09 07:45 PM
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
comments AutoSize CG Rosén Excel Programming 2 November 29th 03 11:20 AM


All times are GMT +1. The time now is 05:36 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"