Get the TEXT of Clicked Shape

[exceere]

Hi, i need a help

I have Three Shapes their texts are A, B, and C

These shapes all have the same name (UF_SinlgeList)

i use the following code to get the text of clicked shape

Please Login or Register  to view this content.

when i click shape A the returned text is B, why???

I attached by file

Thanks for help

[Andy Pope]

All the shapes have the same name. Code simply returns first item in collection matching.

Give your shapes unique names.

[exceere]

Andy Pope, thank you for your quick replay,

in my case i need the the three shapes to be have the same name

[Andy Pope]

In that case then you will not be able to use the same event handler.

Why must the names be the same?

[exceere]

Because is have a User Frame (SingleList) that has a comboox (SLst)

i use the name of the shape to show SinlgeList USERFRAME for the three Shapes by using the following code:

Please Login or Register  to view this content.

and i use the TEXT of the shape to change of the items of the COMBOBOX by following code:

Please Login or Register  to view this content.

Thank you Andy pope
Shape Name and Text.xlsm
i reattached my file with full idea

[Norie]

The shapes don't have to have the same name to call the same macro.

[exceere]

Norie, Thanks

Norie i used the name to show the UF by the following code

Please Login or Register  to view this content.

[Norie]

Why don't you just assign the same macro to each shape?

Please Login or Register  to view this content.

[Andy Pope]

Give the shapes unique names.
Add sub to userform to load given items to list.

[exceere]

Andy Pope, thanks

Your modefying is really excellent

Thanks a million

[exceere]

Norie,

Thank you very much for your trying to help me