How to get GroupShape.Name ( In case 2 or more Group have identical children shapes)

[PhamTrung]

' What code does: I have the following code
' When I click the shape of the group shape, I can get "ParentGroup.Name"

' Problem:
If two group shapes have different children shapes, the macro gives the expected result that I want, but if children's names are completely identical, the result is the name of the source shape, but it is not that I had clicked.

' Example: Gruop_1 has four child shapes, and the child shape names are Shape_1, Shape_2, shape_3, and Shape_4.
Gruop_2 also has the same four child shapes, the child shape names are Shape_1, Shape_2, shape_3, and Shape_4.
When I click Gruop_1, the MsgBox result will be Group_1, but When I click Group_2, the result will also be Gruop_1.

I copied the group shape and only changed the name for the group, the names of the children in that group remained the same.
Is that may be why macros don't work as expected?

What I want to do: How do I get Gruop_2 when I click Gruop_2?
One more Question:
I am holding down the Ctrl key and dragging the left mouse button to copy the shape. are there any changes in the two shapes ❓(Example: shape.ID, shape.Name, etc)

Please Login or Register  to view this content.

[LJMetzger]

Hi and welcome to ExcelForum,

I copied the group shape and only changed the name for the group, the names of the children in that group remained the same.
Is that may be why macros don't work as expected?

Each shape name should be Unique (e.g. 'G3 Switch P4_1')

Application.Caller identifies the name of the Shape that was selected.
When using the name to get a Shape Object, the first name in the list that matches the name is used. The first Shape with the given name will always be the Shape that VBA refers to, including the Group that shape belongs to.

----------------------

I am holding down the Ctrl key and dragging the left mouse button to copy the shape. are there any changes in the two shapes ❓(Example: shape.ID, shape.Name, etc)

No. As far as I know, you have an exact clone, which is the problem. You need different names.

Lewis