Reset Spin Button
 

I am creating a "What If" worksheet to show my employees the impact new
member signups has on our overall percentages. This involves a spin
button to increase or decrease the number of signups. Is there a way,
macro or otherwise, i can have a button to reset the value of the spin
button to 0.

Reset Spin Button
 

Set the spin button's value to zero from any method. If you want it to
be kicked off by a button click, put the line of code (i.e.
SpinButton1.Value = 0) in the Click event of the command button.

stewdizzle wrote:
I am creating a "What If" worksheet to show my employees the impact new
member signups has on our overall percentages. This involves a spin
button to increase or decrease the number of signups. Is there a way,
macro or otherwise, i can have a button to reset the value of the spin
button to 0.

Reset Spin Button
 

Thanks Jeff did exactly what i wanted to do.

wrote:
Set the spin button's value to zero from any method. If you want it to
be kicked off by a button click, put the line of code (i.e.
SpinButton1.Value = 0) in the Click event of the command button.

stewdizzle wrote:
I am creating a "What If" worksheet to show my employees the impact new
member signups has on our overall percentages. This involves a spin
button to increase or decrease the number of signups. Is there a way,
macro or otherwise, i can have a button to reset the value of the spin
button to 0.