Reprogram the [+] key?

[Corey]

Is there a way to "reprogram" the [+] key on the number pad to move right to
the next cell like the [TAB] key does?

I have a user that is data entering information in an Excel list (4-5
columns of data) and would like to keep her data entry hand on the number
pad instead of using the [TAB] key (she's using her left hand to turn pages
and doesn't want to have the extra hand movement from the paper to the
keyboard). Currently she is using the [TAB] key to advance across columns
and the [Enter] key to advance her to the next row ([Enter] is also taking
her to the furthest left column to start her next line of data entry). She
has no need for the math functions on the numberpad in this exercise.

She basically wants to be able to keep her hand on the key pad to advance
from A1 to B1 to C1 to A2 to B2 to C2 to A3 to B3 to C3...

Any ideas? Would I be looking at VB to accomplish this?

Thanks

 

[Earl Kiosterud]

Corey,

I don't think the + key can be reprogrammed. She could instead use the
Enter on the numeric keypad. It can be set to move across instead of down
with Tools - Options - Edit - Move selection after enter - Direction.

 

[Earl Kiosterud]

Corey,

Oooops. I didn't read your second paragraph. She wants to go down, then to
the top of the next column, then down again. For this, first select the
range into which she'll be entering. Now the Enter key (including on the
numeric pad) will move down until it reaches the bottom of the selection,
then to the top of the next column of the selection. She can back up with
Shift-Enter. She must not use any other keys (direction keys, etc.) or the
selection will be lost. It takes a bit of getting used to. She might utter
a few bad words at first when she mistakenly loses the selection, but it'll
work out.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

Corey,

I don't think the + key can be reprogrammed. She could instead use the
Enter on the numeric keypad. It can be set to move across instead of down
with Tools - Options - Edit - Move selection after enter - Direction.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

Is there a way to "reprogram" the [+] key on the number pad to move right
to the next cell like the [TAB] key does?

I have a user that is data entering information in an Excel list (4-5
columns of data) and would like to keep her data entry hand on the number
pad instead of using the [TAB] key (she's using her left hand to turn
pages and doesn't want to have the extra hand movement from the paper to
the keyboard). Currently she is using the [TAB] key to advance across
columns and the [Enter] key to advance her to the next row ([Enter] is
also taking her to the furthest left column to start her next line of
data entry). She has no need for the math functions on the numberpad in
this exercise.

She basically wants to be able to keep her hand on the key pad to advance
from A1 to B1 to C1 to A2 to B2 to C2 to A3 to B3 to C3...

Any ideas? Would I be looking at VB to accomplish this?

Thanks

 

[Roger Govier]

Hi

If you set the Scroll Area of the sheet to be say A1:C50, and have
Tools>Options>Edit>move direction after Enter set to Right, then you
will go as you want
A1,B1,C1,A2 etc.

To set the scroll area, right click on the sheet tab and select View
code.
If the Properties window is not open, press F4 to open it and towards
the bottom of the properties you will see Scroll area.
Enter A1:C50 or whatever would be appropriate to the list of data being
entered.

This setting is not remembered on closing the workbook. You would need
to reset it each time, or have some code in the Workbook Open event or
an Auto_open macro to set it for you each time.

Sub Auto_open()
Sheets("Sheet1").Select
ActiveSheet.ScrollArea = "A1:C50"
Range("A1").Select
End Sub

Change sheet reference and cell references as appropriate.

You could just have it as a macro called SetSheet and invoke it whenever
you want, and a corresponding one to clear the scroll area called
Clearsheet
as follows
sub Clearsheet()
ActiveSheet.ScrollArea = ""
End sub