no need to write any code.
rightclick a toolbar and enable the "Control Toolbox" toolbar.
on this bar click the control called "Scroll Bar", you should be able
to go to the spreadsheet now and place the control on it.
rightclick the control and go to properties: set the Maximum property
to 100, Minimum property to 0 and specify the Linked Cell property e.g
A1.
Now in the top left corner of the Control Toolbox toolbar there should
be a button that is presently selected and says Exit Design Mode when
the cursor is over it: hit this button.
Now try scrolling and hopefully the value in A1 should change with it

J