Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: Lars-Erik on May 28, 2008, 12:59:03 PM

Title: Line Break in ShapeSheet Cells
Post by: Lars-Erik on May 28, 2008, 12:59:03 PM
I know I've seen it somewhere (on this forum even!) but for the live of me I cant find it anymore!

How do I add an enter to a text field, so:

"Hello"&pagebreak&"World!"

--->

Hello
World!

- Lars

Title: Re: Line Break in ShapeSheet Cells
Post by: Visio Guy on May 28, 2008, 03:59:42 PM
Hi L-E,

You can create a new line or carriage return or enter or whatever it is called in a ShapeSheet cell like this:

User.txt = "Hello" & CHAR(10) & "World"

or CHAR(13)
Title: Re: Line Break in ShapeSheet Cells
Post by: Lars-Erik on May 29, 2008, 04:36:05 AM
Thanks, I'm sure there's something like "insert(line)" aswell. But this will do just fine!

- Lars
Title: Re: Line Break in ShapeSheet Cells
Post by: Visio Guy on May 29, 2008, 09:20:05 AM
No, I don't think there is...
Title: Re: Line Break in ShapeSheet Cells
Post by: Lars-Erik on May 29, 2008, 10:39:46 AM
I still cant find it and I'm starting to doubt myself  :-X

Anyway, if anyone else has trouble with any char related stuff, I found this page (http://office.microsoft.com/en-us/visio/HA011331361033.aspx) which has all char() listed.

- Lars