tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,832
- Office Version
- 365
- 2019
- Platform
- Windows
Normally one refers to a shape by its name, such as:
The problem I have is my worksheet contains two shapes with the same name.
So instead, I would like to refer to the shape that is clicked by its position, relative to the worksheet, ie what is its top left, so I can tell which row it's on.
Is this possible?
Thanks
Code:
Dim ShapeName As String
ShapeName = Application.Caller
The problem I have is my worksheet contains two shapes with the same name.
So instead, I would like to refer to the shape that is clicked by its position, relative to the worksheet, ie what is its top left, so I can tell which row it's on.
Is this possible?
Thanks