Try using Word Art. You can do it with that.

--
Regards,
Tom Ogilvy


"John Coleman" wrote in message
oups.com...

John Coleman wrote:
Tom Ogilvy wrote:
As originally stated, the drawing toolbar textbox does offer this
option.
If you only see a single tab when you right click on the textbox and
select
format, then you need to move your cursor out to the edges (the
selection
outline) and right click. then you will get the full range of
options
under format.

--
Regards,
Tom Ogilvy


"PCLIVE" wrote in message
...
Thanks for the reply Tom. Unfortunately, it looks like you do not
have
the
option to rotate when using a "Text Box". I was originally using a
Text
Box
from the Control Toolbox toolbar. Then based on your suggestion, I
saw
another Text Box option in the Drawing toolbar. In trying that, the
rotate
option was still not available.

I was, however, able to rotate a standard rectangle shape.
Unfortunately,
if I've entered text in the rectangle when I rotate it, the text
does not
rotate with the rectangle.

Any ideas?

Thanks,
Paul

"Tom Ogilvy" wrote in message
...
It is one of the properties of the textbox from the drawing
toolbar.

--
Regards,
Tom Ogilvy


"PCLIVE" wrote in message
...
Is there a way to rotate a textbox so that the displayed text
will be
sideways?

Thanks,
Paul

I have the same problem that Paul has. On the format text box dialog
rotation is greyed out. If I set a shape variable, shp, equal to the
text box and execute the code shp.IncrementRotation 30, there is no
effect but the code shp.IncrementLeft 30 has the desired effect, so I
know that I have the object reference set correctly. Maybe the ability
to rotate textboxes was added after excel 2000.

-John Coleman

Going back in the thread, I see that 90 degree was assumed. Properly
speaking, the orientation of the text is changed on the alignment tab,
but the box itself isn't rotated. Is there way to rotate the text box
itself through arbitrary degrees in such a way that the text rotates
with the box? I have wanted to do this in the past and couldn't.

Thanks
-John Coleman