| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
line break character
Why does a multiline string value from a form textbox display the linebreaks
{chr(10)} as little squares when saved to a cell? Can these little squares be suppressed from the cell viewing by using a different ascii character for the linebreak? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
line break character
use replace3 to remove the chr10
MyString = replace(MyString,chr(10),"") "joeeng" wrote: Why does a multiline string value from a form textbox display the linebreaks {chr(10)} as little squares when saved to a cell? Can these little squares be suppressed from the cell viewing by using a different ascii character for the linebreak? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
line break character
On 6 jan, 17:28, Joel wrote:
use replace3 to remove the chr10 MyString = replace(MyString,chr(10),"") "joeeng" wrote: Why does a multiline string value from a form textbox display the linebreaks {chr(10)} as little squares when saved to a cell? *Can these little squares be suppressed from the cell viewing by using a different ascii character for the linebreak?- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - If you want the linebreak kept use: MyString = replace(MyString,chr(10),vbNewLine) HTH, Wouter |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
line break character
Joel, Thanks. It turns out that the linebreak inserted in form textboxes is chr(13) & chr(10) rather than just chr(10) and the offending character is the chr(13). So, substituting chr(13) in your suggestion works "Joel" wrote: use replace3 to remove the chr10 MyString = replace(MyString,chr(10),"") "joeeng" wrote: Why does a multiline string value from a form textbox display the linebreaks {chr(10)} as little squares when saved to a cell? Can these little squares be suppressed from the cell viewing by using a different ascii character for the linebreak? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
line break character
vbnewline adds a chr(13) & Chr(10) "RadarEye" wrote: On 6 jan, 17:28, Joel wrote: use replace3 to remove the chr10 MyString = replace(MyString,chr(10),"") "joeeng" wrote: Why does a multiline string value from a form textbox display the linebreaks {chr(10)} as little squares when saved to a cell? Can these little squares be suppressed from the cell viewing by using a different ascii character for the linebreak?- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - If you want the linebreak kept use: MyString = replace(MyString,chr(10),vbNewLine) HTH, Wouter |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
line break character
No, vbnewline is platform specific. For instance, on the Mac, it's the
CHR(13) character (ony). In article , joeeng wrote: vbnewline adds a chr(13) & Chr(10) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
| Corrupted CSV file- '!' character and line break | Excel Programming | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| Parse data where break is a first uppercase character in a string? | Excel Worksheet Functions | |||
| How can I use a Macro to set a Page break after a character. | Excel Programming | |||
Linear Mode
