Code needed to test if user clicked a button

Hi all

Please can anybody help I need the correct syntax, to check If a user has
clicked on a button .

Regards

Subs

You would need to handle that in the click event of the the button. Then
you wouldn't have to text, because the code would execute when they click
the button.

Beyond that, you would need to be much more specific about what type of
button you are working with and when you would want to determine this
information and why -- what you want to do.

--
Regards,
Tom Ogilvy


"Subs" <atof31@dsl.pipex.com> wrote in message
news:ejd6evowFHA.720@TK2MSFTNGP10.phx.gbl...
> Hi all
>
> Please can anybody help I need the correct syntax, to check If a user has
> clicked on a button .
>
> Regards
>
> Subs
>
>

Subs,
If it's a button on a worksheet from the forms toolbar then
Application.Caller returns the button's name. If you want to identify
the button using its caption eg "Start" then try:
Dim WhichButton as Shape
Set WhichButton = ActiveSheet.Shapes(Application.Caller)
If WhichButton.TextFrame.Characters.Text = "Start" then do something..
Other than that I really don't know. I mainly work on a Mac so I know
nothing about ActiveX controls.
Ken Johnson