Character limit in text box when linked to a cell?

I'll spare you the details on why and just tell you that I've got a text box in Excel 2010 that I linked to a cell by selecting the text box, clicking in the formula bar, and inserting a reference to the cell. My problem is that for some reason, the text box will only show about the first 256 characters from that cell and cuts off the rest. Is there a limit to the number of characters you can display in a text box when linked this way? Is there any way around this?

Yes, there is a limit. You can paste the text into the text box rather than link it to a cell.

Hope this helps.

Pete

Is there a way around this? I want the text box to update automatically. The spreadsheet will be used by many different people with varying degrees of understanding of Excel so I'm trying to keep it very basic for the user.

I work with Excel 2007. I have the same problem and the same requirements as mfernandes.
Also, I do not understand the logic behind this very low limit of 255 characters for a text box...

Did anyone ever get the bottom of this or find a work around? I'm facing the same issue.

I found a work around!

It seems that the 255 character limit is only applied when pulling text from a cell using a formula. You can achieve more characters (in my case around 350) by simply copying the text from the cell and pasting into the text box.
This of course is a manual solution which just wouldn't do. But a simple bit if VBA code can automate this. You may also need to adjust the formatting of the text box as it resets itself. This can also be applied using VBA.

This is my code - adapt to suit:

Please Login or Register  to view this content.

Hope that can help someone facing a similar issue

Well, the thread is nearly 3 years old, but thanks for that solution.

Pete