Spin box increase value only

[Mark N]

Can i set up a spin box so that you can only increse the value 1 increment
and not decrese it. But have a reset button to reset value to "0"?

 

[Jim Thomlinson]

Not without using VBA code... To that end there is no good reason to use a
spinner button. End users will click on the down arrow and when it does
nothing they will assume it is broken an ask you to fix it.

Add 2 Command buttons to your workbook. One called increment and on called
reset. Attach these macros to their respective buttons...

Public Sub Increment()
with range("A1")
.Value = .Value + 1
end with
end sub

public sub Reset()
range("A1").value = 0
end sub