Reprogram Enter Key on worksheet activate

[jaslake]

Is there code for worksheet activate event that will reprogram the Enter Key to mimic the Tab Key such that if you hit Enter, the cell to the right of the active cell is selected? I've searched the net for several hours today and find nothing that addresses this question.

Also, the Enter Key would have to be normalized on worksheet deactivate.

Thanks for your help. J

[Palmetto]

Place this bit of code in the sheet module. After making an entry into a cell and pressing the Enter key it will select the next cell to the right.

Please Login or Register  to view this content.

[jaslake]

Hi Palmetto. I appreciate your input and this line of code does indeed change the operation of the Enter key. Unfortunately, it's impact is erratic. I have other lines of code in the procedure that direct the cursor to specific cells and your line of code is "coat tailing" on the other code lines and sending the cursor to the wrong place.

What I'm really interested in is an "Activate Event" on this particular worksheet that will allow the Enter Key to function the same as the Tab Key (move right). I've not seen this issue addressed on any website so I suspect it's not doable.

Any other suggestions?

Thanks. J

[shg]

Perhaps in the sheet module (completely untested),

Please Login or Register  to view this content.

[jaslake]

Thanks Shg...I believe that's got it. I'll play with it for a while to see if I can break it.

By the way, I'm not getting email notifications. I don't know if the forum is being blocked by my mail server or what. I used to get them but had to reload the system. Perhaps you could provide me with the email address so I can add to my safe senders list.

J

[jaslake]

Shg...as you were aware (I wasn't), the code you provided changes the setup options in Excel such that the enter key is modified to move right upon pressing the key. And, that's exactly what I wanted it to do.

Thus far, it appears that the code in the deactivate event does not "always" reset excel setup option to move down when the enter key is pressed. It appears to be inconsistent, sometimes it does and sometimes it doesn't.

I'll keep playing with it to see if I can figure out when it does and when it doesn't but does anything come to mind for you?

[shg]

You may need to initialize iDir in the workbook Open event instead of the worksheet Activate event, in which case it needs to be a public variable in a code module.

[jaslake]

I'll try that. Any idea about the email issue?

J

[shg]

Check your subscription options, and if they're properly set, contact an admin.

[jaslake]

I received a runtime error on the Worksheet Deactivate line of code when iDir was initialized in Worksheet Open. So, I put eveything back according to your original code and then changed the Worksheet Deactivate line of code thus:

Please Login or Register  to view this content.

This seems to work for the moment. I've been playing with it for about 30 minutes and haven't broken it yet.

Thanks for your help.
J

[shg]

That will work, as long as that's the direction you always use.

The poinbt of caching it was to work with any direction.