I use a macro that points to word´s libraries, that allows me to extract, given a word, some terms (synonyms and antonyms). Afterwards, using a button that refers to a Form, I plot the extracted data on a scatterplot. Up to here no problem!
My need is to "do this research from the chart" by clicking on each label present on the scatterplot in order to update it.
Let me explain better: after the click on a single label chosen from Sheet3 the procedure should:
- Write to cell A2 of Sheet2 the name of the selected label
- Recall the Sub m (), Sub mCopy (), Sub mColor ()
in order to update the graph on Sheet3.
To better explain my question I have attached the work file.
Best regards
Antonino
Bookmarks