Microsoft Excel Spinner's

[Guest]

Is there a way to increase the maximum value allowed in a spinner box to
something greater than 30,000?

 

[dominicb]

Good afternoon BBazan

Any integer is an acceptable value for a spinner (the Microsoft
recommended range is from -32,767 to 32,767, but you can set it up to
go higher). I have just set one up that goes up to 100,000 without
problem. I imagine that the emphasis here is on the word
"recommended".

HTH

DominicB

 

[Dave Peterson]

There are two spinners. The one from the Forms toolbar is limited to 0 to
30000.

But if you're trying to allow the spinner to go from 25000 to 350000 (say), you
could use a limit of 0 to 5000 and a helper cell that adds 25000 to the linked
cell.

Or if the spinner is on a worksheet, you could replace the forms toolbar version
with the spinner from the control toolbox toolbar version.

(The one dominicb used.)