I want the tab key to move to a specific cell, not the next one along. How please?

[Manchester Gunners]

It's while since I have been on the site, but I have googled this and not found the answer:


What I want to do is enable the cursor to move to a specific cell and not the next one. So instead of going from A1 to A2 as is normal, I'd like it to go to A4 etc.

Is it possible?

Thanks in advance

Antony

[AskMeAboutExcel]

Would be helpful to understand more about how you want it to behave. Note that typical 'Tab' behaviour would be to move from A1 to B1, not A2.

One option is to lock cells, and protect the worksheet with 'Select Locked cells' unticked. Tab will then skip to the next unlocked cell. The downside of course is if you want to change the data / don't want to protect the sheet.

Another is to use VBA to change behaviour when you press the Tab key in excel.

To do this, add this as code under 'ThisWorkbook' (note it will only work when you reopen the workbook with macros enabled). This will detect if Tab is pressed.

Please Login or Register  to view this content.

Then insert a new module with instructions of what happens when the above code is triggered. In the below example it simply moves you to Cell A4, but it can be made more sophisticated depending on what you are trying to achieve.

Please Login or Register  to view this content.

Word of caution though - if someone else is picking up the workbook they might end up very confused if you use the VBA approach when it pressing keys doesn't follow the behaviour they are expecting!

[Manchester Gunners]

Thank you. Locking cells will do the trick. Lateral thinking required.