Hi Jae,

Thanks for your reply. Is there any way to do this using text boxes from
the drawing toolbar?

To the best of my knowledge, there is no way automatically to alter this
text box's dimensions in response to its text content.

A drawing objects text box has a size property which allows for the static
sizing of the box. This text box also has a 'Move and size with cells'
property which allows the text box's dimensions to change in response to the
changes in a cells dimensions.

If you want an auto-dimensioning text box, I think that the Control toolbox
is the way to go.


---
Regards,
Norman



"Jae" wrote in message
...
Norman,

Thanks for your reply. Is there any way to do this using text boxes from
the drawing toolbar?

Jae

"Norman Jones" wrote:

Hi Jae,

If you use a Text box from the Control Toolbox, you can set the Autosize
property for the text box to True.

Click the top left icon to go into design mode. Click the top right icon
to
open the text box property window.

---
Regards,
Norman



"Jae" wrote in message
...
Does anyone know a way to have the text box auto adjust the height
according
to the amount of text?