Shape Selection Event !!

Hi all,

I would like to be able trigger an event procedure everytime a Shape is
selected by the User . I know that there is no such native events for
Worksheet Shapes but I was wondering if anyone could come up with a
workaround WITHOUT using a Timer as this would make the Code much less
performant.

Regards.

Possibly use the onaction property of the shape to assign a macro to - this
will fire when the shape is clicked.

--
Regards,
Tom Ogilvy

"RAFAAJ2000" <RAFAAJ2000@discussions.microsoft.com> wrote in message
news:6A06E716-EB96-4122-987B-749007489C0B@microsoft.com...
> Hi all,
>
> I would like to be able trigger an event procedure everytime a Shape is
> selected by the User . I know that there is no such native events for
> Worksheet Shapes but I was wondering if anyone could come up with a
> workaround WITHOUT using a Timer as this would make the Code much less
> performant.
>
> Regards.

Thanks Tom,

What I meant was Selecting the Shape Not Clicking on It ...the same as when
you want to move it or change its size .

Regards.



"Tom Ogilvy" wrote:

> Possibly use the onaction property of the shape to assign a macro to - this
> will fire when the shape is clicked.
>
> --
> Regards,
> Tom Ogilvy
>
> "RAFAAJ2000" <RAFAAJ2000@discussions.microsoft.com> wrote in message
> news:6A06E716-EB96-4122-987B-749007489C0B@microsoft.com...
> > Hi all,
> >
> > I would like to be able trigger an event procedure everytime a Shape is
> > selected by the User . I know that there is no such native events for
> > Worksheet Shapes but I was wondering if anyone could come up with a
> > workaround WITHOUT using a Timer as this would make the Code much less
> > performant.
> >
> > Regards.
>
>
>

When I select a shape, I click it.

However, I doubt there is going to be a way for you to trap the selection of
a shape.



--
Regards,
Tom Ogilvy


"RAFAAJ2000" <RAFAAJ2000@discussions.microsoft.com> wrote in message
news:160F0EBD-C0A7-473F-BDAF-0C393C5B98EE@microsoft.com...
> Thanks Tom,
>
> What I meant was Selecting the Shape Not Clicking on It ...the same as
when
> you want to move it or change its size .
>
> Regards.
>
>
>
> "Tom Ogilvy" wrote:
>
> > Possibly use the onaction property of the shape to assign a macro to -
this
> > will fire when the shape is clicked.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "RAFAAJ2000" <RAFAAJ2000@discussions.microsoft.com> wrote in message
> > news:6A06E716-EB96-4122-987B-749007489C0B@microsoft.com...
> > > Hi all,
> > >
> > > I would like to be able trigger an event procedure everytime a Shape
is
> > > selected by the User . I know that there is no such native events for
> > > Worksheet Shapes but I was wondering if anyone could come up with a
> > > workaround WITHOUT using a Timer as this would make the Code much less
> > > performant.
> > >
> > > Regards.
> >
> >
> >