If your order of entry is left to right and top to bottom then Kevin's
suggestion is a good one.

If a random order see Bob Phillip's site.

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

You could also use event code to jump around. If interested, post back.


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 15:33:01 -0800, ibgolfn
wrote:

I think that is what it is called.

How do I get the focus to go through a defined sequence of cells after
hitting tab or enter.

I have made a Questionaire with cells to accept the answers. I would like
the users to be able to jump from one "answer cell" to the next with only one
key stroke (either tab or enter).

Thanks,

Scot