Identifying the selected Shape

[Jerry]

I have lots of buttons on a sheet. They all start the same sub. How can
I tell which button was clicked? I'd like to get the underlying row. I
see the TopLeftCell method, but I don't know how to tell which is the
selected Shape.

Thanks for helping;
Jerry

[Greg Wilson]

Try:

Sub GetTopLeftCell()
With ActiveSheet.Shapes(Application.Caller)
MsgBox .Name & vbCr & .TopLeftCell.row
End With
End Sub

Regards,
Greg

"Jerry" wrote:

> I have lots of buttons on a sheet. They all start the same sub. How can
> I tell which button was clicked? I'd like to get the underlying row. I
> see the TopLeftCell method, but I don't know how to tell which is the
> selected Shape.
>
> Thanks for helping;
> Jerry
>
>