Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
events
Hi,
Are there any way to trap the selection of a shape on a workshhet through an event? jacob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
events
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 "jacob" wrote in message ... Hi, Are there any way to trap the selection of a shape on a workshhet through an event? jacob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
events
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 Bernie Deitrick wrote: 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 "jacob" wrote in message ... Hi, Are there any way to trap the selection of a shape on a workshhet through an event? jacob -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling Events | Excel Discussion (Misc queries) | |||
events? | Excel Discussion (Misc queries) | |||
Need some events... | Excel Programming | |||
events | Excel Programming | |||
events | Excel Programming |