I am trying to set up an excel order form - I have created the form but I
would like the tab or cursor to move/transition to specific fields not all of
them. When hitting the tabs or arrow keys it is a lot of repetitive motion.
Would like to go from say a1 to a4 to b5 to k12 etc

Does anyone know of a way to do this?

Cindy

There are a few methods of achieving this.

See Bob Phillips's site for a couple.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You could also employ event code to jump around to non-contguous random cells.

If interested, post back.


Gord Dibben MS Excel MVP

On Thu, 17 Jan 2008 15:24:01 -0800, Cindy
wrote:

I am trying to set up an excel order form - I have created the form but I
would like the tab or cursor to move/transition to specific fields not all of
them. When hitting the tabs or arrow keys it is a lot of repetitive motion.
Would like to go from say a1 to a4 to b5 to k12 etc

Does anyone know of a way to do this?