fixed TextBox with Shrink to fit text
 

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

--
I Love Excel

fixed TextBox with Shrink to fit text
 

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.

--
Rick (MVP - Excel)


"Yahya Al-Tawil" wrote in message
...
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

--
I Love Excel