how do i create a scroll option presenting a changeable figure?
 

I gained a recent document from a client who showed a changable figue within
a scroll bar. the way it works is that the scroll bar represents 100% of this
figure and whilst scrolling side to side, the percentage of the figure
changes!
this was all in excel, is there a simple way of creating this scroll bar?

how do i create a scroll option presenting a changeable figure?
 

Go View: Forms Tools and the pick the spinner. Right click on the spinner to
set the parameters

Here's a quick article on how to set up the Forms Tools

http://www.kan.org/tips/excel_forms_tools.php

--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"VK" wrote:

I gained a recent document from a client who showed a changable figue within
a scroll bar. the way it works is that the scroll bar represents 100% of this
figure and whilst scrolling side to side, the percentage of the figure
changes!
this was all in excel, is there a simple way of creating this scroll bar?