Can I resize text boxes if more text is put in

[dpaton05]

I have a text box that needs to be several lines big but sometimes more text may need to be entered. If this is the case, I need everything else on the spreadsheet to be pushed down and the text box just expanded, as the text box is near the top of the page. How is this done?

 

[My Aswer Is This]

Is this a Activex Textbox

 

[My Aswer Is This]

If this is a Activex Textbox then:
In Developer mode:
1. Right click Activex Textbox
2.Choose Properties
3. Chosse Multiline=True
4. Choose AutoSize=True
5.Choose Wrap Text=True

Now the Textbox will grow as you enter more text.

 

[dpaton05]

I got that bit working but it won't resize the text box if more text gets entered. Can you have the text box auto expand down if the text won't fit and push everything else on the page down?

 

[My Aswer Is This]

Well when I want to enter more text I can either just click after last character and start typing.
If I want a new line I press Control and Return

I don't know how you would get the page to shift everything down

And it's always best to say sheet not page.

Your saying you want to enter data into a Activex Textbox and somehow as you type more and more you want the Textbox to automatically expand downward. Which is what Autosize already does. But then you want all the rows on your sheet to move down.

I would not know how to do that.