Copy code using VBA to another worksheet's charts

[halo_]

Hi all, newbie over here!

I am trying to capture co-ordinates on a graph, creating tangents across those points and then determining the intersection point. I have managed to do that with a Shift+click MouseDown combination, but I need to be able to turn this into an add-in in order to use it across any graph, rather than just the one graph it's written in. It includes a UserForm, which allows the user to tell the code which point is being clicked.

But I'm now stuck! I can import the UserForm into another workbook, and the accompanying code inside it, but the bulk of the code sits inside the Chart sheet itself. How do I get VBA to copy that to any/all chart sheets in the new workbook?

Thanks in advance!
Helen

 

[Dryver14]

not sure if this helps but can you save the chart as a template then use the template to create future charts how you want and then run the code?

 

[halo_]

not sure if this helps but can you save the chart as a template then use the template to create future charts how you want and then run the code?

Potentially... The original data to be analysed comes from a different piece of equipment so I'm not sure but I will look into this as an option! Thank you.