It is a control that you can add to a worksheet or a userform that has an up
and a down arrow on it. Clicking the up arrow increments the spinbutton
value, clicking the down arrow ... well I am sure you can work that one.

You can use the value of the Spinbutton in another control, such as a
textbox as a means of quickly cycling through some values (I forgot to
mention that the Spinbutton also has max and min value properties, which
helps bound the cycle).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Louise" wrote in message
...
Hi all

I don't mean to sound ignorant but what's a Spinner Button???

Thanks.

Louise

"Bob Phillips" wrote:

Using code you just set the value to 1

Spinbutton1.value =1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anauna" wrote in message
...
I am using a spinner button to increase/decrease values in a chart.
Is
there a way to reset the spinner so that it returns to it's original
(lowest)
value without having to use the up/down arrows or knowing what value
you
started at?
--
Thank-you and all suggestions are appreciated.