Re: Zooming on Charts with VBA
Hi Rob,
Thanks for the feedback, i see your point with the 'on error resume next' always a dangerous option!
The changes made don't seem to resolve the problem. When the rectangle is drawn to show the required zoom area this prevents the 'mchtChart_MouseUp' in the CChart class operating. I checked this with a breakpoint in the sub and it never runs. However if you comment out the mousemove portion to modify the rectangle when the mouse is pressed it does fire the 'mchtChart_MouseUp' action and the zoom occurs.