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

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