View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1961_] Rick Rothstein \(MVP - VB\)[_1961_] is offline
external usenet poster
 
Posts: 1
Default 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