how to increase/ decrease cell value incrementally?

[naira]

Hi!

I need help in finding a method whereby I can increase/ decrease the value of a cell incrementally by a pre-determined value (to be entered in a particular cell of the same sheet or another sheet or workbook)), by pressing up/down or left/right keys of the keyboard.

The request is for something similar to what is done by a spin button, but the up/ down functions of the spin button need to be done by the left/right keys of the keyboard.

Please note that I would not prefer a macro, since it does not allow undo. If there is any method where undo can be activated with macros, same is welcome.

thanks,

Naira

[Md Aejaz]

hi naira,

create a new column containing both the reference of the cell for which value has to be increased or decreased(Source) and the amount of value that has to be reduced or increased.(input).



1.put the formula having source cell reference address relatively
2.use necessary operator between source and the input .
make the input cell reference as absolute.

=a1*$b$1

the $ dollar symbol indicates the absolute cell reference .

Hope this will solve Your problem.



please rate if u are satisfied with this post.

[jason.b75]

First insert a spinbutton from the forms toolbar.

Right click the spinbutton and click 'format control' then set the values as below.

Current value 15000
Min value 0
Max value 30000
Incremental change 1
Cell link. Use a cell that will bve hidden behind the spinbutton in the worksheet.

Next insert a formula into the worksheet where you want the value to be increased / decreased, change the descriptions shown in red to match your cell references.

=Original value+(spinbutton link cell-15000)*pre-determined increment value

Note that this fomula needs to be in a separate cell to the original value, you can not change the original value directly without the use of vba.

The exception would be if the original value is already the result of a formula where it should be possible bo combine both formula.