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.

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.

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.