sswcharlie
New Member
- Joined
- Jun 26, 2005
- Messages
- 45
- Office Version
- 2016
- Platform
- Web
Excel 2016
Where can I find pages that 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 could not find the arguments for point etc Thanks
Charles Harris
Where can I find pages that 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 could not find the arguments for point etc Thanks
Charles Harris