Is there a way to rotate a textbox so that the displayed text will be
sideways?

Thanks,
Paul

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

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

Paul,
Make sure you right click on the border of the text box (from the Drawing
toolbar), not the text area.

NickHK

"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

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

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

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

Thanks Tom,

As previously stated, I was originally using a Text box from the Control
Toolbox. Then I tried the Text box from the drawing toolbar and when trying
access the "Properties" of this text box, I was unable to locate it. Then I
realized that you meant the "Format Text Box..." option when right-clicking.
So I did find what you were talking about on the Alignment tab. That does
what I want. Now, out of curiosity, do you know if this (rotated text) can
be done with a Text Box from the Control Toolbox? I may have the need to
link the Text Box to a cell which will contain data the may change. Based
on what I've seen, it doesn't look like it can be done this way. Any ideas?

Thanks again for your help.
Paul


"Tom Ogilvy" wrote in message
...
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

To link the textbox that you have, select it, go to the formatting toolbar,
enter an Equal sign and select the cell you want to link, Hit enter.

--
Regards,
Tom Ogilvy

"PCLIVE" wrote in message
...
Thanks Tom,

As previously stated, I was originally using a Text box from the Control
Toolbox. Then I tried the Text box from the drawing toolbar and when
trying
access the "Properties" of this text box, I was unable to locate it. Then
I
realized that you meant the "Format Text Box..." option when
right-clicking.
So I did find what you were talking about on the Alignment tab. That
does
what I want. Now, out of curiosity, do you know if this (rotated text)
can
be done with a Text Box from the Control Toolbox? I may have the need to
link the Text Box to a cell which will contain data the may change. Based
on what I've seen, it doesn't look like it can be done this way. Any
ideas?

Thanks again for your help.
Paul


"Tom Ogilvy" wrote in message
...
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