There is an alternative that does not require code. Just create a
cell link for the spin button that goes from 0 to 20 (assume that
cell is C1). Then create a link to that cell in cell B1 that says
=C1-10. You can hide one or both cells under the spinner button if
you wish.
Now just use cell B1 as cell that you want values to go from -10
to +10. You can do this type transformation for other purposes.
If you need numbers to go from 1% to 20% just divide the link cell by 100.
Pieter Vandenberg
: 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
: :> That's because you can't set the linked cell property <0, you would need
:> code for this
:>
:>
:> --
:>
:> Regards,
:>
:> Peo Sjoblom
:>
:> :> > 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.
:> >
:>
:>
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.