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.