auto size text in a shape? (not the other way around)

[kedas]

I want the text to auto size depending on the variable size of the shape and variable text length.
I know it easy to change the shape to wrap around the text but that is not what i want.

Does someone know how that can be done?

Thanks

Visio 2007

[Paul Herber]

http://www.visguy.com/2007/08/21/text-resizing-with-shapesheet-formulas/