Changing the Spin Button Interval

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top