Microsoft Excel Spinner's
 

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

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=388019

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.)

BBazan wrote:

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

--

Dave Peterson