Build 4.0.0.69 of xlsgen adds a VBA macro association property for a number of existing objects including :
- pictures
- text boxes
- vector shapes
- charts
- and also pictures, text boxes and vector shapes inside charts
This VBA macro association lets a user click on the object and trigger a macro. This was introduced in form controls earlier this year and has now been extended to all other objects in Excel.
Lets say you have an existing VBA macro called process in the spreadsheet in a VBA module. There is a property in the text box interface, called VBAMacro which you can invoke with mytextbox.VBAMacro = "process". And that's all it takes.