Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Controlling which cell you go to when Tab is entered
I have a form where it would be most convenient for the user to be able to
fill it out in a certain order. Is there a way, when either "Tab", "Enter" is hit the cursor will move to a specific cell? For instance, I'd like it to move from C2 to C3, to C4, to F2, to H3 to F3 to B14 etc.... thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Controlling which cell you go to when Tab is entered
See Bob Phillips' site for a couple of methods.
http://www.xldynamic.com/source/xld.xlFAQ0008.html There is another method using sheet event code to control Tab order. If interested post back. Gord Dibben MS Excel MVP On Wed, 22 Aug 2007 08:22:01 -0700, carrera wrote: I have a form where it would be most convenient for the user to be able to fill it out in a certain order. Is there a way, when either "Tab", "Enter" is hit the cursor will move to a specific cell? For instance, I'd like it to move from C2 to C3, to C4, to F2, to H3 to F3 to B14 etc.... thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data changes when entered into a cell | Excel Worksheet Functions | |||
Run a macro if a certain value is entered in a cell | Excel Worksheet Functions | |||
Formula to see if a cell has an entered value | Excel Worksheet Functions | |||
Last cell entered | Excel Worksheet Functions | |||
Controlling Cell/Cursor Placement | Excel Discussion (Misc queries) |