variable length more than 1024 - how to show string complete in excel?

[NorTor]

Hello!


I have a table in an excel-sheet showing my contacts.
I use a VBA-loop to add up the emails of my contacts and store them in
a string variable (separated by an ';' of every contact).

Problem is, it adds up to about 4000 characters total.

The cell that I have chosen to display the complete variable shows
only the first 1024 characters of the string value.

Is there a way using VBA I can show the full 4000 character string?


Best regards
NorTor

 

[Dave Peterson]

Try changing the separator to vblf (chr(10)).
And set the cell's wraptext to true.

If you add these alt-enters to a cell (every 80-100 characters), you can see
lots more of the string.

Maybe a nicer alternative--a userform with a text box on it???