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

  • Thread starter Thread starter Tim
  • Start date Start date
T

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
 
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
 
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
Click to expand...

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.
 
Back
Top