A way to increase a number in a cell by using the + key

[Tim]

Hi, i do a lot of data entry and am looking for a way to increase the
number in a cell (or range of cells) so that i dont have to enter the
new number in each time. I have columns that separate items and i use
the sheet to show the total count for each item in it's row.
eg
Item 1 Item 2 Item 3
2 5 4

I'd like to use the + key only to increase the counts for each item.
Did i make sense?? It's a Friday and my mind isn't quite up for a lot
of detailed explanations, lol.

Any assistance would be appreciated.
Tim

 

[Gord]

That would require VBA

How far are you willing to go with that?

Have a look at the Forms Toolbar and create spin buttons linked to
each cell.


Gord Dibben Microsoft Excel MVP

 

[Salmon Egg]

Hi, i do a lot of data entry and am looking for a way to increase the
number in a cell (or range of cells) so that i dont have to enter the
new number in each time. I have columns that separate items and i use
the sheet to show the total count for each item in it's row.
eg
Item 1 Item 2 Item 3
2 5 4

I'd like to use the + key only to increase the counts for each item.
Did i make sense?? It's a Friday and my mind isn't quite up for a lot
of detailed explanations, lol.

Any assistance would be appreciated.
Tim

I have not been able to understand what you wanted even after reading
your post three times. Please realize that we only have what you typed
to go by. Wo you gave the example of values 2 5 4 in what I presume
are three cells somehwer. What next?

--

Sam

Conservatives are against Darwinism but for natural selection.
Liberals are for Darwinism but totally against any selection.

 

[GS]

Tim formulated the question :

Hi, i do a lot of data entry and am looking for a way to increase the
number in a cell (or range of cells) so that i dont have to enter the
new number in each time. I have columns that separate items and i use
the sheet to show the total count for each item in it's row.
eg
Item 1 Item 2 Item 3
2 5 4

I'd like to use the + key only to increase the counts for each item.
Did i make sense?? It's a Friday and my mind isn't quite up for a lot
of detailed explanations, lol.

Any assistance would be appreciated.
Tim

As Gord suggests, it would require VBA to do what you ask. *However*,
assigning a keyboard shortcut to a macro requires at least the Ctrl key
plus another key. That means you may be able to use 'Ctrl' and '+'.
Since the '+' key is used in formulas I'd suggest you pick an alpha key
like 'Crtl+i', for example, which could be shorthand for 'increase'.
Similarly, 'Crtl+d' could be used to 'decrease' the value. Optionally,
you could prompt the user for the amount to increase/decrease a
quantity of selected cells.