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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.