Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Microsoft Excel Spinner's
Is there a way to increase the maximum value allowed in a spinner box to
something greater than 30,000? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
Microsoft Excel is waiting for another application to complete an OLE action | Excel Discussion (Misc queries) | |||
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel |