Sliding value bar?

[barrysworkshop]

I thought I saw in an add-in or somewhere where a slide bar was added to an
Excel worksheet, assigned a min and max value and associated with a cell.
Then by sliding the bar you change the cell value and the values of cells
using that whose formulas reference that cell. I am creating a game and
trying to determine a good starting population, land for housing, land for
food, how much food should each unit of land produce, growth rate, etc. so
you can see where it would be useful to have several of these to help me
"tweak" my numbers. Does anyone know what I am talking about and how can I
put one in my spreadsheet?

 

[JLatham]

I believe what you're looking for is the Spin Button and it's in the 'Control
Toolbox'. To get to the Control Toolbox, choose View | Toolbars and choose
it from the list. If you double-click it once you get it on the worksheet,
it'll take you into the VB Editor where you can set the properties (Linked
Cell, Min and Max) that you're interested in using.

 

[JLatham]

Barry,
I should have added that once you get it on the worksheet, you can also
Right-Click it and choose [Properties] from the popup list to get to the
values you need to set for it. Probably easier than going thru the VB Editor.