Scroll Bar Max-Min Limits
Posted by Valerie on January 28, 2002 6:17 PM
I need to create a scroll bar on a spreadsheet. The scroll bar needs to have a Min Value of 1 and a Max value of 99,999. I also need to have the scroll bar work in increments of 1 (all whole numbers between the max and min should appear). The problem is that the highest value that the control will allow you to use is 30,000. I thought of putting the result in a separte cell and using 11,111 as the Max value and then multiplying it by 9. However, that means that the smallest number I can get is 9. E.g. - when the scroll bar answer equals 1, the formula equals nine and when the scroll bar answer equals 2, the formula equals 18. I need a way for it to show all numbers between 1-99,999.
Any help would be greatly appreciated!