Is it possible to call a common vba macro on a commandbutton ?

[josh2008]

Hi
Hope this can be done is Word etc (I can in LibreOffice etc).
I wish to use many command buttons in a document, these buttons basically control external hardware. I would need to call a VBA code that gets the caption from the sending button and then send this caption to a shell program.

I can create a button, but I cannot assign any events as such, I can create the code; but this for each button.


I would like to be able to copy paste a button, and just change the caption for the new button for it to work.


I cannot find a way to use a custom macro with the button click event.


Button I am using, is Legacy CommandButton


Hope that makes sense.