My worksheet contains multiple images, in which I have programatically been trying to configure a mouse click event for each.
Here is what I have up to now:
Code
FName = ThisWorkbook.Path & "\Charts\" & ws.Name & ".GIF"
Worksheets("Charts").Activate
ActiveSheet.Pictures.Insert(FName).Select
Selection.OnAction = "OnMouseClick"
My problem is, when I raise the mouse click action on the image, it calls a Sub procedure, but doesnt pass any parameters.. I'm trying to figure out how to get a "FUNCTION" to be called instead, so that I can pass a few parameters along with the mouse click.
I'm open to new methods and suggestions,