Shape does not display all the text

[SDV]

Hi,

I am creating a form that displays some content in a dynamic text box. The text box is linked to a cell with a simple =$A$5 formula in the formula bar. The linked cell ($A$5) has a formula that picks the content to be displayed.

However the textbox is only showing me a part of the content. The text just disappears after a certain character. I've tried changing the font sizes, text box sizes, and the formula that pulls the content. Can anyone help me with this, please?

Thanks
SDV

 

[Chihiro]

When you use cell reference to shapes. There is character limit of 255.

Use ActiveX textbox with Multiline property set to True, instead.

See discussion on subject in thread below.
http://chandoo.org/forum/threads/text-box-linked-to-cell-displays-cropped-text.33526/

 

[SDV]

That worked perfectly! Thank you, Chihiro!