VBA to read "Name" of macro button

[Goepfi]

I would like to assign a macro to different "buttons" on a sheet - each button will be given a name ("define name")
When clicking on the "button" i would like to start a VBA (assign macro) and the macro should goto a cell on another sheet (with "application.goto reference...") - so far so good.

Now to avoid having 10 macros, I would like to give a name to each "button" and when I click on the button I would like to first "read" the name of the button (store it in a variable) to use this as the reference target to goto... (By using the variable in stead of a "fix" name...

Question clear? Thanks a lot for your help on what function to use to read the name of the "clicked active button" and store it in a variable.

Merci

Goepf

[Norie]

Goepf

You can use Application.Caller to get the name of the button that was clicked.