Spinner Button Reset

[Guest]

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?

 

[Bob Phillips]

Using code you just set the value to 1

Spinbutton1.value =1

--

HTH

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

 

[Guest]

Hi all

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

Thanks.

Louise

 

[Bob Phillips]

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)

 

[Guest]

Thanks, Bob.

How do you create one??

Louise

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)

 

[Dave Peterson]

There are two spinnerbuttons that you can put on a worksheet.

If you show the Forms toolbar and the control toolbox toolbar, you can let your
cursor linger over the icons.

When you see "Spinner" (on the Forms toolbar) or "Spin Button" (on the Control
toolbox toolbar), click on it.

Then back to the worksheet and draw a little box (you can resize it later).

If you chose the spinner from the forms toolbar, right click on it and choose
format control. There are lots of tabs where you can set stuff (especially the
Control tab).

If you chose the spin button from the Control Toolbox Toolbar, right click on it
and choose Properties. You can scroll through that list of properties and see
lots of stuff you can change.

 

[Guest]

Hi Dave

Thanks very much for this. I've never used them before so will give it a go.

Louise