alo guys i really need help here...
i use VB to link with excel to produce a shape objects.
but i got difficulty to put a multiple row text.

shape1.TextFrame.Characters.Text = SCN & vbCrLf & rsGet!ves_name

the vbcrlf is printed to a character in the textframe.
how to get rid the character off, but i can use the multiple rows....

and how to use the multiple row tooltiptext...

VB only provide one row tooltiptext only....

thanks to all of you ...

aliank