paste into shape object's text property

[mike]

I'm trying to write a vba routine that will paste the contents of the
clipboard into a textbox or process shape's text propery. Any ideas?
Thanks.

 

[Paul Herber]

I'm trying to write a vba routine that will paste the contents of the
clipboard into a textbox or process shape's text propery. Any ideas?

It's not easy to find.

look at the shape object's Characters object then the Paste method of
that.

shape.Characters.Paste

 

[John Marshall, MVP]

If you are not worried about text formatting or replacing the content of a
shape, you can use:

ShapeObj.Text = TextString

or


ShapeObj.Text = ShapeObj.Text + " " + TextString

to add it to the end of the current shape's text.

John... Visio MVP

Need stencils or ideas? http://visio.mvps.org/3rdparty.htm
Need VBA examples? http://visio.mvps.org/VBA.htm
Visio Wishlist http://visio.mvps.org/wish_list.htm