VBA Chart Active Point Number into Variable

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
859 views
0

Excel 2016
What page on this site best covers the arguments etc for vba charts

I want to click on a data point and then run a macro. Will use mouseover etc. The main thing at the moment what is the code to get the number and pass it to a variable. Say myTar and something like – (each time macro run on different data point)

Active.Point.number(myTar)

Once in a variable I can use it from there.
I am a bit new to vba and above probably no where near correct, but hope you get the idea.
I could not find the arguments for point etc Thanks
Charles Harris

Simply the best place to learn Excel VBA