| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the Spin Button Interval
How do I change the spin button interval? Right now when I click it it
always moves up or down by 1, while I want it to move by 0.05. Thanks Adam Bush |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing the Spin Button Interval
Adam,
From Help: A Spinbutton returns: "An integer between the values specified for the Max and Min properties." So, you cannot use an interval less than 1. But you can simply divide the returned value by 20, and increase the values of the Max and Min by factors of 20 to compensate. HTH, Bernie MS Excel MVP " m wrote in message ... How do I change the spin button interval? Right now when I click it it always moves up or down by 1, while I want it to move by 0.05. Thanks Adam Bush |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing the Spin Button Interval
Thanks for your help Bernie. That's what I figured.
Adam Bush "Bernie Deitrick" wrote: Adam, From Help: A Spinbutton returns: "An integer between the values specified for the Max and Min properties." So, you cannot use an interval less than 1. But you can simply divide the returned value by 20, and increase the values of the Max and Min by factors of 20 to compensate. HTH, Bernie MS Excel MVP " m wrote in message ... How do I change the spin button interval? Right now when I click it it always moves up or down by 1, while I want it to move by 0.05. Thanks Adam Bush |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| spin boxes | Excel Worksheet Functions | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
| spin button value | Excel Discussion (Misc queries) | |||
| Set Increment on Spin Button to 0.1 | Excel Discussion (Misc queries) | |||
| How do I setup a spin button in excel | Excel Discussion (Misc queries) | |||
Linear Mode
