Increment and subtract Numbers
 

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

Increment and subtract Numbers
 

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.
--
Allllen


"JohannM" wrote:

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

Increment and subtract Numbers
 

http://office.microsoft.com/en-us/as...265211033.aspx
more here :-)
--
Allllen


"JohannM" wrote:

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