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)
"Mark" wrote in message
...
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
|