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!



Posted by Ivan F Moala on January 29, 2002 3:37 AM

Hi Valarie
Use the scrollbar from the Control Toolbox
this is An ActiveX control the limit on this is 999,999,999.....provides for more control via
programing.


Ivan