Using the mouse wheel scroll up/down event to change graph axis

[Cookstein2]

Hi,

Is there away to make the minimum and maximum scales on a graph change by scrolling up or down with your mouse wheel, so in effect you could artificially zoom in or out on your chart?

[Andy Pope]

You would need to use API to capture mouse scrolling events as other than a few activex controls, which you can not use on a chartsheet, no scrolling events are exposed.

This is a VB6 example but you might be able to adapt it if you think it is worthwhile
http://www.vb6.us/tutorials/interfaceing-scroll-mouse

[Cookstein2]

Hi Andy

Thanks for your reply, I'll have a look at the example, it may take a while, I'm very much a VBA beginner