How to tell if text in shape is overflowing / autofit

[geejay]

Hi all,

Is there a function/formula to tell if if text in shape is overflowing? I.e
if the text is outside of the shape?

I'm trying to build an autofit function which grows a shape depending upon
text.

Thanks

 

[Paul Herber]

Hi all,

Is there a function/formula to tell if if text in shape is overflowing? I.e
if the text is outside of the shape?

I'm trying to build an autofit function which grows a shape depending upon
text.

Have a look at the TextWidth function:

http://msdn.microsoft.com/en-us/library/aa195587(office.11).aspx

 

[geejay]

OK, using TextWidth(TheText) to resize a shape horizontally to fit text works
fine. Still not sure how to tell if text is overflowing or not...

 

[Paul Herber]

OK, using TextWidth(TheText) to resize a shape horizontally to fit text works
fine. Still not sure how to tell if text is overflowing or not...

Width gives you the width of the shape.
TextWidth(TheText) tells you how wide the text is.
Compare the two.