Is there a newline character?

  • Thread starter Thread starter Meilu
  • Start date Start date
M

Meilu

Hey Smart People,

I'm trying to concatenate a few strings together.

I would like to insert newline characters ... but
the "/n" doesn't work in VB.

I looked in "help" but I can't find it. Just wondering
if this character exists in VB?

Thanks,
Meilu
 
Meilu,

vbCrLf is the vba constant for the CaridgeReturn/LineFeed characher.

You can also use Chr(13) as ASCII characher 13 is the same as vbCrLf.

HTH,
Josh
 
-----Original Message-----
Hey Smart People,

I'm trying to concatenate a few strings together.

I would like to insert newline characters ... but
the "/n" doesn't work in VB.

I looked in "help" but I can't find it. Just wondering
if this character exists in VB?

Thanks,
Meilu

.
I think it's Chr(13)
Click to expand...
 
Small correction
Chr(13) & Chr(10)
You need both and in that order for a carriage return/line feed. If
you have only one you will see square boxes in your text.
Click to expand...

.... and of course the vbNewLine which is OS-sensitive, so its CR/LF on the
PC, CR on Unix, LF on the Mac etc etc.

Are there any Unix applications that host VBA ?-- oh, Internet Explorer, I
suppose.


All the best


Tim F
 
Back
Top