I have been asked to automate Excel through VB6 to produce a scatter graph. I have managed this fine but a further requirement (I suspect of Excel VBA rather than VB) is to have an informative msgbox displayed when the user clicks on any of the scatters.

The msgbox will return the value (x and y) of the scatter point - Eg. "Dealer Name, Trade Value". Currently clicking on any point on the graph puts you into graph edit mode and I can not see how I could VBA/macro instruct such a requirement.

I have seen this done before and wonder if anyone knows how.

Thanks,

Paul.