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?
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?