Thread
:
Identifying Button Clicked
View Single Post
#
1
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
Identifying Button Clicked
Assume these are buttons from the forms toolbar
Sub Btn_click()
Dim btn as Button
set btn = Activesheet.Buttons(Application.Caller)
rw = btn.topLeftCell.row
End Sub
Application.Caller returns the name (a string) of the button triggering the
macro.
--
Regards,
Tom Ogilvy
"Mister T" <Mister
wrote in message
...
I have on a spreadsheet several buttons that trigger the same macro. Let's
say one of the buttons is in row 1, another in row 3, another in row 5, etc.
If the row 1 button is clicked, I want the macro to act on row 1; if the row
3 button is clicked, I want the macro to act on row 3; etc. Therefore, I
need the macro to "know" which one of the buttons called it. Can that be
done, and how? Thanks.
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy