Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center text in a shape textframe
I need to center text in an autoshape oval's text frame. It works fine in
Excel 2007 by using the text frame and inserting a single letter as a character with no additional instructions. However, after loading it at work in Excel 2003 the character is barely visible in the lower left hand corner of the oval. I inserted the horizontalallingment to center horizontally but I can't get the verticalalignment to work. Any suggestions? Thaks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center text in a shape textframe
If you right-click the oval's non-text area and select "Format AutoShape"
from the popup menu that appears, you will get a dialog box with 8 tabs on it... click the Alignment tab and set the Text Alignment there. Then, when you type your text in the text area of the oval, it will take on whatever alignment you selected. Rick "DaveL" wrote in message ... I need to center text in an autoshape oval's text frame. It works fine in Excel 2007 by using the text frame and inserting a single letter as a character with no additional instructions. However, after loading it at work in Excel 2003 the character is barely visible in the lower left hand corner of the oval. I inserted the horizontalallingment to center horizontally but I can't get the verticalalignment to work. Any suggestions? Thaks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center text in a shape textframe
Rick,
Thanks. That worked to show me what the real problem is. I didn't mention I'm coding this in VBA, but I got the same result by working with the shape on the worksheet directly. The real problem is that it works until the shape gets so small then the character moves to the bottom of the oval. If I make the oval bigger then it is clearly cnetered, vertically and horizontally, but as I shrink it the letter stays horizontally centered but moves to the bottom of the oval. Is there any way to get it to center when the shape is small? "Rick Rothstein (MVP - VB)" wrote: If you right-click the oval's non-text area and select "Format AutoShape" from the popup menu that appears, you will get a dialog box with 8 tabs on it... click the Alignment tab and set the Text Alignment there. Then, when you type your text in the text area of the oval, it will take on whatever alignment you selected. Rick "DaveL" wrote in message ... I need to center text in an autoshape oval's text frame. It works fine in Excel 2007 by using the text frame and inserting a single letter as a character with no additional instructions. However, after loading it at work in Excel 2003 the character is barely visible in the lower left hand corner of the oval. I inserted the horizontalallingment to center horizontally but I can't get the verticalalignment to work. Any suggestions? Thaks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center text in a shape textframe
Working on the worksheet directly... I cannot duplicate the problem you are
describing. As I shrink the oval's size, the text remains centered. If I shrink it so the text no longer fits, then the text is cropped and what remains visible is still centered. Rick "DaveL" wrote in message ... Rick, Thanks. That worked to show me what the real problem is. I didn't mention I'm coding this in VBA, but I got the same result by working with the shape on the worksheet directly. The real problem is that it works until the shape gets so small then the character moves to the bottom of the oval. If I make the oval bigger then it is clearly cnetered, vertically and horizontally, but as I shrink it the letter stays horizontally centered but moves to the bottom of the oval. Is there any way to get it to center when the shape is small? "Rick Rothstein (MVP - VB)" wrote: If you right-click the oval's non-text area and select "Format AutoShape" from the popup menu that appears, you will get a dialog box with 8 tabs on it... click the Alignment tab and set the Text Alignment there. Then, when you type your text in the text area of the oval, it will take on whatever alignment you selected. Rick "DaveL" wrote in message ... I need to center text in an autoshape oval's text frame. It works fine in Excel 2007 by using the text frame and inserting a single letter as a character with no additional instructions. However, after loading it at work in Excel 2003 the character is barely visible in the lower left hand corner of the oval. I inserted the horizontalallingment to center horizontally but I can't get the verticalalignment to work. Any suggestions? Thaks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center text in a shape textframe
Rick,
OK. Not sure what might solve this for me except to go back in Excell 2007, rework it, and try to reload it back in Excel 2003. Thanks for your time. Dave "Rick Rothstein (MVP - VB)" wrote: Working on the worksheet directly... I cannot duplicate the problem you are describing. As I shrink the oval's size, the text remains centered. If I shrink it so the text no longer fits, then the text is cropped and what remains visible is still centered. Rick "DaveL" wrote in message ... Rick, Thanks. That worked to show me what the real problem is. I didn't mention I'm coding this in VBA, but I got the same result by working with the shape on the worksheet directly. The real problem is that it works until the shape gets so small then the character moves to the bottom of the oval. If I make the oval bigger then it is clearly cnetered, vertically and horizontally, but as I shrink it the letter stays horizontally centered but moves to the bottom of the oval. Is there any way to get it to center when the shape is small? "Rick Rothstein (MVP - VB)" wrote: If you right-click the oval's non-text area and select "Format AutoShape" from the popup menu that appears, you will get a dialog box with 8 tabs on it... click the Alignment tab and set the Text Alignment there. Then, when you type your text in the text area of the oval, it will take on whatever alignment you selected. Rick "DaveL" wrote in message ... I need to center text in an autoshape oval's text frame. It works fine in Excel 2007 by using the text frame and inserting a single letter as a character with no additional instructions. However, after loading it at work in Excel 2003 the character is barely visible in the lower left hand corner of the oval. I inserted the horizontalallingment to center horizontally but I can't get the verticalalignment to work. Any suggestions? Thaks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to retrieve text from the textframe of an oval shape in Excel? | Excel Programming | |||
Interesting problem with VBA generated textbox (or textframe of shape) length | Excel Programming | |||
how do I use a macro to center a shape in a cell in excel | Excel Programming | |||
Hyperlink within the TextFrame of Shape Object..? | Excel Programming |