Controlling which cell you go to when Tab is entered

[Guest]

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

 

[Gord Dibben]

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