About Us

Nigel[_2_]

Thank you

--

Regards,
Nigel

"Andy Pope" wrote in message
...
Hi,

You need to code in the Scroll event

Private Sub ScrollBar1_Scroll()

' update code here

End Sub

Of course if you use named ranges then no code is required.
http://www.andypope.info/charts/Scrolling.htm

Cheers
Andy

Nigel RS wrote:
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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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
Scrolling Charts with scrollbar	Nigel[_2_]	Excel Programming	0	March 1st 08 08:27 AM
"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

Menu

About Us