Question on autosize

[mortgageman]

In a different (Mr. Excel of course) post, I learned about autosize for Userform textboxes. As I understand it, autosize will auto size a single textbox, based on the content. Is there a command that will autosize a number of vertically stacked textboxes?

Gene Klein

 

[mortgageman]

In a different (Mr. Excel of course) post, I learned about autosize for Userform textboxes. As I understand it, autosize will auto size a single textbox, based on the content. Is there a command that will autosize a number of vertically stacked textboxes?

Gene Klein

I guess not.

Gene Klein

 

[GTO]

Greetings Gene,

Do you mean to equally size them?

Mark

 

[mortgageman]

Greetings Gene,

Do you mean to equally size them?

Mark

No - proportionally size them based on their content.

Gene Klein

 

[GTO]

...Is there a command that will autosize a number of vertically stacked textboxes?

Hi again,

I am afraid I am not following. If you have the several textboxes' AutoSize Property set to True, then each one will size itself as you enter text. If each textbox sizing itself is not what you are asking, could you explain what you mean?

Mark

 

[mortgageman]

Hi again,

I am afraid I am not following. If you have the several textboxes' AutoSize Property set to True, then each one will size itself as you enter text. If each textbox sizing itself is not what you are asking, could you explain what you mean?

Mark

I thought I did, but no biggie. I will just hard code the heights. Thank you anyway.

Gene Klein