How to know which shape as triggered the userform

[kebec_ska]

I need to determine which shape has been clicked to get the column of this shape.

So I have multiple shapes in a worksheet and they all have the same name... (Automated generation) but they are in different culumns.

Each shape has the same sub associated to his .Onaction which is a simple .show sub

Please Login or Register  to view this content.

Then at Userform_Initialize() I need to know which one has been clicked on.

The problems is:
- They all have the same name so this get the first named as the one clicked on in the shapeS collection

Please Login or Register  to view this content.

And the sheet must remains locked... So no selection...

Any ideas?

[Norie]

Why do all the shapes have the same name?

That's going to make it pretty hard (impossible?) to tell which one was clicked.

[shg]

Why not give them unique names?

Edit: Yeah, what Norie said. Or unique captions.

[kebec_ska]

The problem started has the shape is created with a generated column with datas ans then the datas are sorted horizontaly and the shapes doesnt follow the .insert shift to right...
So the shapes have a common name the prevent any mistakes of shape name / data in the column..

In addition to that, at generation, it must have a "Fill*" like name to it but the following number should follow the last one generated.. but its generated one a while so cant get a trace of last one created..

[Norie]

Why do they need to have the same name?

Doesn't that just cause confusion, as it is for your userform question?

[kebec_ska]

Or i can simply add the follownig integer of my usedrange.columns.count the the "Fill*" name... after sorting they wont match but i'll get the topleftcell.column anyway...