Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter data and press enter to move to specific cell
after enering data how can I press enter to move to a specific cell?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter data and press enter to move to specific cell
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 On Tue, 9 Jan 2007 19:11:00 -0800, Programing problem wrote: after enering data how can I press enter to move to a specific cell? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter data and press enter to move to specific cell
If the sheet is protected and selection of locked cells is not allowed, the
next unlocked cell determined by the setting of ToolsOptionsEditMove 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 "Programing problem" wrote in message ... after enering data how can I press enter to move to a specific cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Press Enter and Move Back to Column A Automatically | Excel Discussion (Misc queries) | |||
Selection won't move when I press enter...do you know why? | Excel Discussion (Misc queries) | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
After entering data, press enter to move to a specific cell | Excel Programming | |||
must press enter 2x to move cell focus | Excel Discussion (Misc queries) |