![]() |
Sliding value bar?
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? |
Sliding value bar?
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. "barrysworkshop" wrote: 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? |
Sliding value bar?
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. "barrysworkshop" wrote: 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? |
All times are GMT +1. The time now is 12:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com