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.

[gmayor]

Select Design Mode from the Controls group. Right click the button > View Code. Use that code to call your macro.

[josh2008]

Hi


Thanks for your reply, but that is doing exactly what I do not want to do.

I would like to be able to copy and paste a button, then change its caption and then for it to work, without having to go in and change the code.


I have also found no way for the code to interrogate the sending buttons properties as the application.caller does not appear to be available in word, yet is in excel