I need to change what the "Enter" button does once it reaches a certain cell.

Hi Everyone,

I just recently got familiar with VBA and I'm trying to figure it if it may be the best solution for me to accomplish my task. I currently use a foot petal to read measurements on a caliper. The foot petal acts as an "Enter" key and once a measurement is recorded it sends it to the spreadsheet and moves down a row. Now after a certain amount of "Enter" hits how can I program Excel, of a working template, to move over lets say a few rows to the right and couple rows up. Once it has done this I would like to continue to keep doing the rows like it did previously.

Examples would be once I get to A25 to move to B15 and then continue to go B30 and move to D13. Again using the "Enter" to do all this.

Is it possible, since I mentioned It would be very beneficial if didn't have to go back and check the screen every

Thanks in advance if anyone can help me get the basics down on this.

The freezing did not work. I believe VBA could solve my issue, I just do not know how to set it up myself and my knowledge is limited currently.

Dan

Dmaracic,

Attached is a sample workbook using the example you specified in your original post:

Examples would be once I get to A25 to move to B15 and then continue to go B30 and move to D13. Again using the "Enter" to do all this.

The code acting in Sheet1 is:

Please Login or Register  to view this content.

With that, the cursor will move to the desired cells using only the Enter key.

Hope that helps,
~tigeravatar

Thank you tigeravatar, It works but only on your spreadsheet maybe 2010 has some compatibility issues. I'll try and see if it works for me tonight, I'll update in the morning.

Dan

Tigeravatar,

This is what I'm working with. Code should be in there as-well.

Every red line i want it to go a green. following your example i added extra rows to make the macro work. In your template it works just fine, In mine it does not however.

Thanks for the help once again

Please Login or Register  to view this content.

Dmaracic,

Right away I can tell you the issue is because of merged cells. When you go to a merged cell, it automatically selects both of them, which means Target.Cells.Count > 1, which is causing this line to return TRUE and then exit the subroutine:

Please Login or Register  to view this content.

Deleting that part of the line lets the macro run, but the fact that you're using merged cells is messing it up altogether. If you can adjust your sheet to not have merged cells, it should work for you

~tigeravatar