I learn something from you every time I read your posts Tom, you go above
and beyond ... pls keep going!!!!!!!!!
"Tom Ogilvy" wrote in message
...
So, I am asking if there are systems which REQUIRE chr(10) to add a line,

In a msgbox where Excel is supported, I doubt it. All these work:
(comment out all but the one to test)

Sub aa()
a = Chr(10)
a = Chr(13)
a = vbLf ' chr(10)
a = vbCrLf ' chr(13) & chr(10)
a = vbCr ' chr(13)
a = vbNewLine
MsgBox "abcdefg" & a & "hijklmnop"
End Sub

I am not aware of a Unix version of Excel, so I think it only supports
Windows and MAC. There was a version that supported a RISC processor
(forget which one), but that was back around the Excel 5 time frame I
believe.

However, for DOS (and I assume windows) at least, the line termination
character is defined to be CrLf. I know Unix only uses one, I believe
chr(10) and MAC only uses one (chr(13)).

for cross system support, I would imagine most modern software does not
strictly require both CrLf for text files.

--
Regards,
Tom Ogilvy


"William Benson" wrote in message
...
Nick, my point is that I only, ever, use Chr(13) and it always pops me
down
to the next line. Every time.

So, I am asking if there are systems which REQUIRE chr(10) to add a line,
because I have found no Windows apps ever do.

In other words, VBCRLF and Chr(13) do the same thing in a message box, a
list box, etc.

From my experience anyway.

"Nick Hebb" wrote in message
oups.com...
On Windows VbCrLf is equivalent to VbNewLine, so every time that you've
used either one you've implicitly used chr(10) - line feed.

I imagine that the other systems that use only chr(13) - carraige
return - would primarily be Macs.