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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BinaryD" wrote in message
...
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.