Home » Forums » Open Source Learning Center » Question and Answer

Shape properties

Submitted by dickgoossens on 26 October, 2011 - 12:02

I'm looking for a list containing the shapes in Excel and their properties. For example: Right Triangle has .height, .width, .top, .left etcetera but I imagine there are a lot more, but which? I want to be able to change the text in this Right Triangle, but there is no .text property.

Thanks

‹ Log linear (money market) interpolation "Pricing derivatives" Help me Please with a Sorting Problem. ›
»
Vishesh's picture

I would suggest you record a

Submitted by Vishesh on 29 October, 2011 - 11:25.

I would suggest you record a macro for this and modify it as per your requirement.

Sheet1.shapes("shp").TextFrame.Characters.Text="Your Text"

However, its not easy to list all the properties of an object.

»