I’m lost. I can kind of muddle my way through VBA with Word, but I just don’t “get” Excel.
I’m trying to trap a keypress and increment the value of the adjacent cell (or current cell if that will work) based on whether + or – is pressed. I’m figuring this needs something to do with the Change event and then Offset to get the correct cell. Here’s what I’m after (in something not resembling real VBA/Excel functions at all)…
Use mouse or keyboard to move cursor to any cell in column D
Press either + or – key on keypad
If Key = – Then CellValue in same row in column C = CellValue – 1
If Key = + Then CellValue = CellValue + 1
Can anyone point me in the right direction?
Thanks,
-Steve