How to get carriage return in mtext

I am sure this sounds very stupid, but I need to insert some "returns" in my
mtext. I tried:

mytext & chr$(13)

and

mytext & "\n"

But it still puts all of my text on one line.

I can't seem to find anything in the help file. Te examples show only a
single line.

Thanks,
Conan Witzel

 

Embed "\P" in your text.

Regards

Wayne Ivory
IT Analyst Programmer
Wespine Industries Pty Ltd

 

You could also use one of the vb constants. vbCr is a carriage return which puts the cursor to pos 0 on the same line, vbLf moves the cursor to its current position on the next line, vbCrLf puts the cursor at pos 0 on the next line.

--
----
Ed
----
Embed "\P" in your text.

Regards

Wayne Ivory
IT Analyst Programmer
Wespine Industries Pty Ltd

 

Oops, still early in the morning, I didn't notice "mtext". I need a cup o' joe.

--
----
Ed
----
You could also use one of the vb constants. vbCr is a carriage return which puts the cursor to pos 0 on the same line, vbLf moves the cursor to its current position on the next line, vbCrLf puts the cursor at pos 0 on the next line.

--
----
Ed
----
Embed "\P" in your text.

Regards

Wayne Ivory
IT Analyst Programmer
Wespine Industries Pty Ltd

 

Thanks,

Conan