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.
Show all shape properties
-
- Administrator
- Posts: 12612
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Show all shape properties
StuartR's suggestion is probably the most efficient way to do what you want.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4930
- Joined: 31 Aug 2016, 09:02
Re: Show all shape properties
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.
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Show all shape properties
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...
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
Hans
-
- PlatinumLounger
- Posts: 4930
- Joined: 31 Aug 2016, 09:02
Re: Show all shape properties
Can we deal with the properties that are not objects only?
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Show all shape properties
Check the list of properties in the link from my previous reply.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4930
- Joined: 31 Aug 2016, 09:02
Re: Show all shape properties
Thanks a lot. I found this link too which will be good start for me
https://submeg.com/2012/06/09/excel-vba ... roperties/
https://submeg.com/2012/06/09/excel-vba ... roperties/
-
- PlatinumLounger
- Posts: 4930
- Joined: 31 Aug 2016, 09:02
Re: Show all shape properties
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/
https://newtonexcelbach.com/2008/09/17/ ... roperties/