Show all shape properties

YasserKhalil
PlatinumLounger
Posts: 4912
Joined: 31 Aug 2016, 09:02

Show all shape properties

Post by YasserKhalil »

Hello everyone
Suppose I have a shape and I would select that shape. How can I get all the properties of that shape?
The purpose of that is that I need to draw exactly similar shapes ..

Thanks advanced for help.

User avatar
StuartR
Administrator
Posts: 12601
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Show all shape properties

Post by StuartR »

Can you use copy and paste to achieve your goal?
StuartR


User avatar
HansV
Administrator
Posts: 78405
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Show all shape properties

Post by HansV »

StuartR's suggestion is probably the most efficient way to do what you want.
Best wishes,
Hans

YasserKhalil
PlatinumLounger
Posts: 4912
Joined: 31 Aug 2016, 09:02

Re: Show all shape properties

Post by YasserKhalil »

In fact, I know that I can use copy and paste but I am curios to know more about all the properties of any shape.

User avatar
HansV
Administrator
Posts: 78405
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Show all shape properties

Post by HansV »

See Shape object (Excel).

A problem is that many properties are objects themselves (for example ControlFormat, Fill and Hyperlink; there are many more). These objects have numerous properties themselves, some of which are objects too...
Best wishes,
Hans

YasserKhalil
PlatinumLounger
Posts: 4912
Joined: 31 Aug 2016, 09:02

Re: Show all shape properties

Post by YasserKhalil »

Can we deal with the properties that are not objects only?

User avatar
HansV
Administrator
Posts: 78405
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Show all shape properties

Post by HansV »

Check the list of properties in the link from my previous reply.
Best wishes,
Hans

YasserKhalil
PlatinumLounger
Posts: 4912
Joined: 31 Aug 2016, 09:02

Re: Show all shape properties

Post by YasserKhalil »

Thanks a lot. I found this link too which will be good start for me
https://submeg.com/2012/06/09/excel-vba ... roperties/

YasserKhalil
PlatinumLounger
Posts: 4912
Joined: 31 Aug 2016, 09:02

Re: Show all shape properties

Post by YasserKhalil »

And this another amazing link which has a file (in the file there is a UDF that deals with the shapes and get all the shape properties
https://newtonexcelbach.com/2008/09/17/ ... roperties/