Shrinking text

[lrankin]

I have a Visio drawing that contains shapes and text. When I try to make the
drawing smaller in order to add a description, the shapes get smaller but the
text does not. What is the method to convert the text to a format so that it
will shrink like the shapes do?

Lon

 

[wr]

Hi Lon,

Try the following:
1. open the shapesheet
2. scroll down to the character section
3. in the size cell type the following formula (without the brackets)
assuming that the font size is currently set at 12 pt and the value of the
width cell is 100 otherwise adjust formula accordingly
"=12pt*FORMATEX(Width,"0.00",,)/100"

Result is that when your shapes becomes smaller your text becomes smaller as
well
At some point of time the text will wrap though

Afcourse, this will work if you resize the shape only for the width
but what if you resize the shape only for the height?
you can use the following formula "=12pt*FORMATEX(Height,"0.00",,)/100"
if you resize diagonally both formulas work

in the case your width formula is up and you resize only for the height then
you will have to create a macro or maybe someone knows a better formula

René