scrollbar control of a chart, live or not live

[Brian Murphy]

Hello Excel'ers,

This question is not really a programming question, but here goes.

I'm baffled.

I have a very long list of xy data points.

And I can create a chart that shows just a subset of the data, and by using
defined names with the =OFFSET function, I can use a spinner or scrollbar to
have the chart "move" through the data. All this works fine with no
problems, and I've used this technique a lot.

However, in some of my files the chart is "LIVE". Which means the chart
updates continuously while the spinner or scrollbar is being changed. While
other times the chart does not update until I stop scrolling (i.e., release
the mouse button).

Even on different on worksheets within the same file, the chart on one sheet
may update live, while on another sheet it won't.

It seems like it might to be some property of the Worksheet object, but I've
checked the properties in the VBA properties window, and could find no
differences (EnableCalculation property, for example).

Does anyone know why this is happening?

Thanks,

Brian Murphy
Austin, Texas

 

[Andy Pope]

Hi Brian,

Whenever I have experience this it has been releated to whether the
control was of the forms or control toolbox variety.

forms controls update on completion whereas the control toolbox ones
give the "live" response.

Hello Excel'ers,

This question is not really a programming question, but here goes.

I'm baffled.

I have a very long list of xy data points.

And I can create a chart that shows just a subset of the data, and by using
defined names with the =OFFSET function, I can use a spinner or scrollbar to
have the chart "move" through the data. All this works fine with no
problems, and I've used this technique a lot.

However, in some of my files the chart is "LIVE". Which means the chart
updates continuously while the spinner or scrollbar is being changed. While
other times the chart does not update until I stop scrolling (i.e., release
the mouse button).

Even on different on worksheets within the same file, the chart on one sheet
may update live, while on another sheet it won't.

It seems like it might to be some property of the Worksheet object, but I've
checked the properties in the VBA properties window, and could find no
differences (EnableCalculation property, for example).

Does anyone know why this is happening?

Thanks,

Brian Murphy
Austin, Texas

--

Cheers
Andy

http://www.andypope.info

 

[Brian Murphy]

Hello Andy,

Thanks very much for the tip.

I went to one of my sheets that has a scrollbar that does not work "live".
It was indeed created with the Forms toolbar. So I created one using the
Controls toolbar, and that one does operate "live".

So I guess knowing this, I should be able to reliably create "live"
scrollbars. Which essentially solves my problem.

One thing though, I looked at some my other scrollbars that do work "live",
and some of them were definitely created with the Forms toolbar.

Is it perhaps possible that my mixed results with Forms scrollbars is due to
"inconsistent" behavior on the part controls created with the Forms toolbar?

I copied and pasted a working "live" Forms/scrollbar from one sheet to
another sheet where there was already a scrollbar that was not "live". I
then reassigned the Linked cell, and that scrollbar would no longer work
"live", at least on that worksheet.

I also copied/pasted a non-live scrollbar to another worksheet, reassigned
the cell link, and on that sheet it would work "live".

Go figure?

It seems to have something to do with the worksheet. But I don't see what
it could be. Anyway, if I use the Controls toolbar from now on, maybe I
won't have this problem.

Cheers,

Brian