View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Buttons click in Code

If you use a button from the Forms toolbar you can do this:

Select Case Application.Caller ''Name of button

--
Jim
"Bettergains" wrote in message
...
Hello:

I realize I can code a button's click event, but would really like to be
able to use a select case statement to take action based on which button
is
clicked. This would then be called in the button's click event. Can this
be
done? How?

Thanks, Germaine