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