Changing the Spin Button Interval

[adambush4242]

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

 

[Bernie Deitrick]

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

 

[adambush4242]

Thanks for your help Bernie. That's what I figured.

Adam Bush