Hi,

I have a text box, "TextBox 1" referencing a cell named "Companies". There is over 255 characters in cell "Companies", hence the need for the VBA code below.

My problem is, the text box does not change and only contains 255 characters, I cannot see the error in the code below.

Your advice will be much appreciated.
K 


Please Login or Register  to view this content.