At first I thought this might be a problem with statement order. I've found
several things, mostly in charting, that used to be insensitive to the order
of the commands but in 2007 the order is important. But even putting
..AutoSize = True at the end doesn't help. The width of the textbox is not
changed by .AutoSize. But I noticed that the height of the textbox is scaled
to fit the width and the amount of text. So Excel is doing something, just
not the same thing it used to do, and not the thing we are expecting it to
do.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"MrT" wrote in message
...
Hi,

I've just noticed that the textboxes are not resized when autosize is set
to
true:

With Worksheets(1)
.Shapes.AddTextbox(msoTextOrientationHorizontal, 12, 12, 12,
12).Select
With Selection
.AutoSize = True
.Characters.Text = "zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz"
.Font.Name = "Arial"
.Font.Size = 8
End With
End With

This works with all previous excel versions. With Excel 2007, you'll get a
vertical textbox with a columns of Zs.

May be they've changed the way to write, from to left to right to up to
down
... just let me know.

Another thing: it is (almost) impossible to catch a shape (textbox) for
example to drag and drop it from one place to another, on a worksheet. If
anyone has a trick I'd like to know it.

Cheers,

MrT