events

J

jacob

Hi,
Are there any way to trap the selection of a shape on
a workshhet through an event?

jacob
 
B

Bernie Deitrick

Jacob,

AFAIK, there is no event triggered by selecting a shape, but you could
easily add a macro to the shape to perform any action you desire.

HTH,
Bernie
MS Excel MVP
 
D

Dave Peterson

And just to add to Bernie's suggestion. It can be the same macro for all the
shapes.

Option Explicit
Sub testme()
Dim myShape As Shape

Set myShape = ActiveSheet.Shapes(Application.Caller)

MsgBox Application.Caller & _
vbLf & myShape.Name & _
vbLf & myShape.TopLeftCell.Address
End Sub
 
Top