• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Text Boxes in 2007

T

Treksterz

New Member
Greetings,


In Excel 2003 I can create a text box and put as much text into it as possible. I can click inside the text box and use arrow keys to scroll through the text while having the text stay inside the box and the size of the box remain the same as when I created it. For some reason, I can't do this with a text box in Excel 2007. The text will bleed outside the box and I can't actually "scroll" through it with arrow keys. Can anyone tell me why this is and how this can be corrected without using VBA?


Thanks much.
 
Are you sure the 2003 text box is the same text box used in 2007? I can confirm your claim that in 2007 the text box (from Insert tab) does bleed out. I would suggest you use the text box from "Developer" tab and once a text box is created, click on "design mode", create the text box, then click the "properties" of the text box you have just created and find "WordWrap".


Once you find it, change the setting to "True". Then you may also consider setting the "scrollbars" to "2 - fmScrollBarsVertical". then exit "Design Mode". Start typing and you should be fine.
 
You must log in or register to reply here.
Back
Top