Screen Tips

[Visio Padawan]

I want to make a list of the custom properties in a screen tip. I have all
the information in but the list isn't all one on top of the other. I was
wondering what the command is to enter a carriage return in the shapesheet,
misc, comments box. Currently this is what I have in there:
=Prop.ID&" "&Prop.1&" "&Prop.2&" "&Prop.3&" "&Prop.4&" "&Prop.5&"
"&Prop.6&" "&Prop.7&" "&Prop.8&" "&Prop.9
As you can see I have the spaces but I can't figure out how to get carriage
return. Thank you.

 

[John]

Padawan,

Use the CHAR function:

=Prop.ID&CHAR(13)&Prop.1&CHAR(13)&Prop.2&CHAR(13)&Prop.3

Best regards

John

 

[Chris Roth [MVP]]

Hi VP,

try this:

Miscellaneous.Comment = Prop.ID & char(10) & Prop.1 & char(10) &....

--
Hope this helps,

Chris Roth
Visio MVP

More Visio shapes, articles, development info and pure diagramming fun at:
www.wanderkind.com/visio

 

[Visio Padawan]

Both ways worked for me. Thanks alot for both of your help.