events

[jacob]

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

jacob

 

[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

 

[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