No, you don't need a macro to do that.

Right click on the menu bar and select the forms toolbar

On the toolbar find the scrollbar control. Click on it, then rubberband an
area on your worksheet where you want the scrollbar.

Right click on the scrollbar and select format control

on the control tab, you can set the min and max values and the incremental
change value. You can also link it to a cell on the worksheet (this is
where the value will be displayed).

There is also a scrollbar control on the control toolbox toolbar. After you
place it, you can right click on it and select properties.

You can set these properties
Min
Max
SmallChange
LargeChange
LinkedCell

--
Regards,
Tom Ogilvy



"hillyer" wrote in message
...
I am beginner with excel so I am not even sure if this is a macro, but I
am
trying to do the following (which I have seen on another spreadsheet).

Have a tool that allows me to click on it and move a bar my mouse up and
down to change the value of a particular cell with in a certain range. So,
for example, if I moved the bar to the top the cell would read 100, if I
moved it to the bottom it would read 0, middle 50 etc... I am sure this is
much easier to do than I think, just looking for help if anyone knows how
to
do this! Thank you!