Real-time update of chart using a Spin Button

[BinaryD]

Excel 2003:

If I use a spin button (form control) to update a cell in the series of a
line (or bar) chart, the chart does not update until I 'let go' of the spin
button. i.e. I click and hold on the spin button and the data is updated in
the relevant cell in the spreadsheet, but the chart will only update when I
stop 'spinning'.

Today, I have seen the updating of a bar/line chart as described above, but
the chart updated in real-time whilst the spin button was held down. The
author of that demo was not aware that he had done anything special to
achieve that effect, and when we compared the spin button control settings in
both his and my worksheets, they both appeared identical.

Can anyone offer any suggestions as to what I have to do to achieve
real-time updating of a chart whilst the spinner is held down?

Thanks in advance.

 

[Andy Pope]

Hi,

Controls from the Forms toolbar will update when released.
Controls from the Control toolbox toolbar will update in real time.

So you need to use the control toolbox version of the spin button.

Cheers
Andy

 

[BinaryD]

Andy, thank you very much for your reply; the ActiveX spinner does indeed
work as you advise.

That solution will suffice, although it will require additional coding, but
I am absolutely certain the spinner I was shown yesterday updating in
real-time was a form control, as we compared the settings. I'll get in touch
with the person who showed it to me and report back.

Thanks again.

 

[Andy Pope]

Hi,

One way to check would be to see what the content of the formula bar is when
the control is selected.
Some like this for a ActiveX control
=EMBED("Forms.SpinButton.1","")

and for a Form control linked to a cell.
=$B$5

Cheers
Andy

 

[BinaryD]

Thanks for the advice. I won't be able to have a look until next week, but I
will provide feedback if possible.