Hello,
On a sheet, I have two shapes (say two Ovals) and an ActiveX button. Let's
select one of the two shapes. I want to know when I click on the button, what
shape was selected before the button got activated. I could not find an
answer after searching for a while as there no event such as beforeclick.
Thanks in advance for any help,
MrT

Well, I've just found the answer: you need to set the TakeTheFocus property
to false ...

"MrT" wrote:

> Hello,
> On a sheet, I have two shapes (say two Ovals) and an ActiveX button. Let's
> select one of the two shapes. I want to know when I click on the button, what
> shape was selected before the button got activated. I could not find an
> answer after searching for a while as there no event such as beforeclick.
> Thanks in advance for any help,
> MrT

If you use a Forms button rather than a Controls button:

Sub WhoGotClicked()
MsgBox (Selection.Name)
End Sub

will tell you which Shape got clicked.
--
Gary''s Student - gsnu200908


"MrT" wrote:

> Well, I've just found the answer: you need to set the TakeTheFocus property
> to false ...
>
> "MrT" wrote:
>
> > Hello,
> > On a sheet, I have two shapes (say two Ovals) and an ActiveX button. Let's
> > select one of the two shapes. I want to know when I click on the button, what
> > shape was selected before the button got activated. I could not find an
> > answer after searching for a while as there no event such as beforeclick.
> > Thanks in advance for any help,
> > MrT

The problem of form buttons is that you cannot control many things such as
background color.

"Gary''s Student" wrote:

> If you use a Forms button rather than a Controls button:
>
> Sub WhoGotClicked()
> MsgBox (Selection.Name)
> End Sub
>
> will tell you which Shape got clicked.
> --
> Gary''s Student - gsnu200908
>
>
> "MrT" wrote:
>
> > Well, I've just found the answer: you need to set the TakeTheFocus property
> > to false ...
> >
> > "MrT" wrote:
> >
> > > Hello,
> > > On a sheet, I have two shapes (say two Ovals) and an ActiveX button. Let's
> > > select one of the two shapes. I want to know when I click on the button, what
> > > shape was selected before the button got activated. I could not find an
> > > answer after searching for a while as there no event such as beforeclick.
> > > Thanks in advance for any help,
> > > MrT

If your interest is in background color, you can assign a macro to any piece
from the Drawing toolbar and assign any color to the shape.

Of course, this ruins your ultimate goal of capturing the shape that got
clicked!
--
Gary''s Student - gsnu200908


"MrT" wrote:

> The problem of form buttons is that you cannot control many things such as
> background color.
>
> "Gary''s Student" wrote:
>
> > If you use a Forms button rather than a Controls button:
> >
> > Sub WhoGotClicked()
> > MsgBox (Selection.Name)
> > End Sub
> >
> > will tell you which Shape got clicked.
> > --
> > Gary''s Student - gsnu200908
> >
> >
> > "MrT" wrote:
> >
> > > Well, I've just found the answer: you need to set the TakeTheFocus property
> > > to false ...
> > >
> > > "MrT" wrote:
> > >
> > > > Hello,
> > > > On a sheet, I have two shapes (say two Ovals) and an ActiveX button. Let's
> > > > select one of the two shapes. I want to know when I click on the button, what
> > > > shape was selected before the button got activated. I could not find an
> > > > answer after searching for a while as there no event such as beforeclick.
> > > > Thanks in advance for any help,
> > > > MrT