Oops! here's the code, be in design mode and double click on the spinbutton
and use this

Private Sub SpinButton1_Change()
Range("A2").Value = SpinButton1.Value
End Sub

(replace A2 with the cell where you want this)

remove the linked cell in the properties but keep max 10 and min -10


--

Regards,

Peo Sjoblom




"Peo Sjoblom" wrote in message
...
That's because you can't set the linked cell property <0, you would need
code for this


--

Regards,

Peo Sjoblom

"Boris" wrote in message
...
I have created a spinbutton and set min and max to -10 and 10 intending
yield
a range but clicking down from 0 gives me 65535.00.