Increment and subtract Numbers

[Guest]

I have a 2 command buttons on my worksheet named "-" and "+". If the a given
cell value is either zero or blank and I click on the "+button" it must
increment the value by 1 and if I click the "-button" it must subtract 1
from the value in the same cell. Your help is appreciated thank you.
JM

 

[Guest]

You can just do this with a spinner button from the Forms toolbar.
Toolbars > Forms
Choose the one call Spinner and bang it in your sheet
Right click on it and do Format Control.

On the control tab, put in the cell link where you want the value to change.
And don't forget to play around with the other options.
It is nice because you don't need any programming for this.

 

[Guest]

http://office.microsoft.com/en-us/assistance/HA012265211033.aspx
more here