Set Increment on Spin Button to 0.1

[Guest]

I'm using a spin button from the control toolbar to increase the value in a
cell.

the min value i want is 0
the maximum is 2

but i want it to increase by 0.1

in the properties this doesn't seem to be allowed

help!!!!

Thanx
Mark

 

[Bob Phillips]

Mark,

Here is one way.

Link your spinbutton to an unused cell (I use) A15. Set the max to 20. Then
in code, set the real cell's value like so

Private Sub SpinButton1_SpinUp()
Range("A16").Value = Range("A15").Value / 10
End Sub

Private Sub SpinButton1_SpinDown()
Range("A16").Value = Range("A15").Value / 10
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)