About Us

Nigel[_2_]

Thanks for the tip scroll event is working

--

Regards,
Nigel

"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"Nigel RS" wrote in message
...
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?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Scrollbar in charts	kay	Charts and Charting in Excel	2	October 8th 08 09:16 PM
Static charts when scrolling	[email protected]	Charts and Charting in Excel	3	April 8th 08 02:12 PM
Dynamic and Scrolling charts	Patrick	Charts and Charting in Excel	2	October 7th 07 12:45 PM
"Scrolling with Scrollbar or SpinButton on UserForm"	Don	Excel Programming	3	July 9th 07 07:50 PM
Scrolling the Worksheet with the scrollbar	Fred Holmes	Excel Discussion (Misc queries)	3	August 16th 05 10:32 PM