ExcelBanter - Buttons assigned to a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Buttons assigned to a macro (https://www.excelbanter.com/excel-programming/276887-re-buttons-assigned-macro.html)

Tokash

Buttons assigned to a macro

Thank you Harald. That's exactly what I needed.

Tok
-----Original Message-----
Hi Tok

Yes:
MsgBox Application.Caller

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Tokash" wrote in message
...
In Excel, if I have several buttons (shapes) assigned to
run the same macro, is there a way within the macro to
identify the button which was clicked on to execute it?

Thanks for any advice!

Tok

.

All times are GMT +1. The time now is 12:28 PM.