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

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 <(E-Mail Removed)>
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