LinkBack URL
About LinkBacks
Now The text box autofit spreads the message on one line right accross the Sheet. What Happened? I am using Excell 2007
Now The text box autofit spreads the message on one line right accross the Sheet. What Happened? I am using Excell 2007
Last edited by tht37; 04-29-2013 at 05:30 AM.
Are we talking about a TextBox or a cell ?
Elegant Simplicity............. Not Always
I believe it should be cell
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
textboxes have an autofit too ;-)
Josie
if at first you don't succeed try doing it the way your wife told you to
Yes a text box. Normally the box surrounds the text in a largish rectangle, but now it surrounds the text in a thin rectangle. For example if the text is 50 letters long then the rectangle is 50 letters long.
change the textbox multiline property to true if it's active x...
Thank you. How do I do that!
Last edited by tht37; 04-29-2013 at 12:05 PM.
1. Go to Excel settings and options ......... Round button, top left of the excel screen
2. Select Excel Options - bottom button
3. Select "Show developer tb in ribbon" 3rd row down
4. selct ok
5. Select the ribbon developer tab
6. Select "Design Mode"
7. Select your textbox ..................... If it won't select it isn't ActiveX
8. Find the multiline property in the properties display list
9. Set to true
10. Resize the textbox to suit
11. Deselect Development
Thank you again... but I can't find the 'Round Button, top left of the excell screen'. I only have the save and print button. I have 'Excell non commercial use'
Last edited by tht37; 04-29-2013 at 12:18 PM.
The weird orange round button
1.jpg
with coloured boxes on it.. Office button
That's the one...... I've put a picture of it on my previous post
Oh I see...... and I have found the bottom button. Will try to complete instructions
Okay have completed up to instruction 8. The properties list doesn't show seem to show multiline
Last edited by tht37; 04-29-2013 at 12:53 PM.
Sounds to me like your textbox is not an ActiveX but a form... Try right clicking on the textbox ... If it selects ok try resizing it
Last edited by AndyLitch; 04-29-2013 at 12:50 PM.
I don't seem to have achieved my goal.. the text box can be resized but when I use autofit it behaves with one long line only again. I couldn't find a multiline reference on the properties list.
Thanks for your help. I have learned a few things!
Last edited by tht37; 04-29-2013 at 01:26 PM.
If the properties were listed then it is activeX, in which case you should be able to select and resize it..
If there is no multiline property it's probably a label and not a textbox....
Can you upload the file - it would save loads of messing about...
Thanks for your help Andy. I'm running out of time. I'll have to think about what I've done. Thanks again
Yeah! You are rightOriginally Posted by JosephP
my assumption failed in this
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks