Rotate a text box?
 

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

Thanks,
Paul

Rotate a text box?
 

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

Rotate a text box?
 

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

Rotate a text box?
 

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

Rotate a text box?
 

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

Rotate a text box?
 

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

Rotate a text box?
 

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

Rotate a text box?
 

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

Rotate a text box?
 

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

Rotate a text box?
 

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

Rotate a text box?
 

In playing around with this, I came across the same thing you suggested.
Didn't seem quite as obvious when I asked the question.

Thanks again for your help,
Paul

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

Rotate a text box?
 

Tom Ogilvy wrote:
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


Thanks Tom,
The only problem is that I don't know of any way to make word-art
text look like normal text. Even if you pick a normal font and
font-size it seems like word art always does something like make the
letters hollow or shaded or some other "artistic" effect, and playing
around with the options only goes so far towards eliminating it. I
haven't tried all combinations, and maybe VBA yields some more
possibilities.

It isn't terribly important to me any more. In a cryptography class I
was teaching last year I had the idea of creating an animation to
illustrate the notion of a transposition-cipher by taking some text,
fragmenting the text with the fragments spinning away as if in an
explosion, and then having the fragments reassamble in a different
order to form the cipher-text. Having the fragments spin away was a
flourish that I decided I could live without.

Thanks again

-John Coleman

Rotate a text box?
 

Maybe morphing using a series of word art objects to create the animated
effect would be more apropo.

--
Regards,
Tom Ogilvy

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

Tom Ogilvy wrote:
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


Thanks Tom,
The only problem is that I don't know of any way to make word-art
text look like normal text. Even if you pick a normal font and
font-size it seems like word art always does something like make the
letters hollow or shaded or some other "artistic" effect, and playing
around with the options only goes so far towards eliminating it. I
haven't tried all combinations, and maybe VBA yields some more
possibilities.

It isn't terribly important to me any more. In a cryptography class I
was teaching last year I had the idea of creating an animation to
illustrate the notion of a transposition-cipher by taking some text,
fragmenting the text with the fragments spinning away as if in an
explosion, and then having the fragments reassamble in a different
order to form the cipher-text. Having the fragments spin away was a
flourish that I decided I could live without.

Thanks again

-John Coleman