Pass text strings longer than 255 characters

I need to pass text strings longer than 255 characters from a cell (A1) to a textbox (TextBox 1) in Excel 2010. Some helpful people gave me this code (I don’t know how to program at all ), which seems to work for earlier versions of Excel, but not in Excel 2010.

Please Login or Register  to view this content.

I get an "application-defined or object-defined error" message in the “.characters(.Characters.Count…” line.

Any help would be great. Thanks!

Regards,

Carry

P.S. First post, first mistake. Sorry RoyUK