View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default 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