Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable length more than 1024 - how to show string complete in excel?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable length more than 1024 - how to show string complete inexcel?
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??? NorTor wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a string of unknown length in a string of unknown length, Help! | Excel Discussion (Misc queries) | |||
How do I set up a Chart in Excel with variable cell length? | Charts and Charting in Excel | |||
how do i get a cell in a sheet to show the last 1024 characters? | Excel Worksheet Functions | |||
Variable-Length String causing error | Excel Programming | |||
Error when string length 1024 and starts with - | Excel Programming |