Scrolling Charts with scrollbar

N

Nigel RS

I have range of time series data on a worksheet from which I display 12
months in a chart. I have added a scrollbar to allow the user to scroll
through the data, moving forward or backwards as required. All works as
expected. But I wish to improve it further.

If I click the scroll arrows the change event moves my data view by +/- 1
month, which is exactly what I want.

If I click and drag the scroll box, the scroll or change events only occur
when the mouse is released. What I would like is for the chart to be updated
as the scrollbar is moved, without releasing the mouse.

Not sure this is possible in VBA, can anyone help?
 
J

Jon Peltier

If you use a Controls Toolbox scrollbar instead of a Forms men slider, you
will get this instantaneous change as the control is scrolled.

- Jon
 
N

Nigel

Thanks for the tip scroll event is working

--

Regards,
Nigel
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top