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

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

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

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

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