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

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

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