| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying Button Clicked
If these are buttons from the Forms toolbar, you can use
Application.Caller to return the name of the button that was clicked. E.g., MsgBox "Button Clicked: " & Application.Caller -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preventing a command button from being clicked twice | Excel Discussion (Misc queries) | |||
| let a sub recognise the name of the button that has been clicked. | Excel Discussion (Misc queries) | |||
| Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
| Detrmine which command button was clicked | Excel Programming | |||
| Button event clicked problem | Excel Programming | |||
Threaded Mode
