fixed TextBox with Shrink to fit text

[Yahya Al-Tawil]

hi
this is my first Question here
can i use Fixed Shape(Rectangels) can make the text inside it shrinking to
fit

becuse this Shape reads data from Cells in my WorkBook
and i want my TextBox To Be Fixed with it size but the text in it shrinking
to the size of the text box
Can I do that Please

 

[Rick Rothstein]

I don't think you can do that (at least I have never seen it done before). I
think one of the problems would be that the font size of individual
characters can be different sizes, so determining what fits could be
difficult to do. To see this, put some text in your shape, select one or
more characters from the center of the text and change the font size to
something bigger than the default.