Enter data and press enter to move to specific cell

G

Gord Dibben

Do you want a programming solution or other?

You can protect the sheet with the cells to move to unlocked and disallow
selection of locked cells.

You can define a named range and follow the sequence of the cells in the named
range.

See Bob Phillips' site for named range method.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You can use Case Select code to move from one cell to another as you press enter
key.


Gord Dibben MS Excel MVP
 
N

NickHK

If the sheet is protected and selection of locked cells is not allowed, the
next unlocked cell determined by the setting of Tools>Options>Edit>Move
selection after Enter will be selected.

If you want to go to some other specific cell, try the method in the recent,
previous thread "how do I put my unprotected cells in order to answer
they're mixed" in this NG.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Copy excel cell to webform (search box) and press enter 10
Excel JUMP FROM SEARCH BAR TO RESULT 3
Where was I before pressing enter/return or tab key 1
User form - How to store data on press of enter key. 2
Macros acting on a filtered list 3
How to code: If active cell is B1, goto H17 when enter pressed 2
data validation, mouse action of select... then move right 2

Top