How do I get round the 255 char limit in a Excel control text box ?
Posted on 2014-03-08
I have an Excel 2010 User form made up of Active X controls. My VBA procedure transfers the sheet data into an array and then populates the relevant text box controls.
However, I have hit a problem. If a sheet cell contains a string of more than 255 characters then the procedure returns an error when populating the text box.
How can I get round this 'string to array to text box' issue in my VBA ?