How to Tab over to a specific cell... not the adjacent one?

[SK]

In order to make a form more user friendly, I would like
to allow the user to use the "Tab" key to jump from one
input field to another (unlike moving to the adjacent
cell).

Is this possible?

Thanks in advance for your suggestions.

Regards,
SK

 

[Don Guillett]

Lock all cells> unlock desired cells>lock worksheet>test

 

[RagDyer]

When using the "protect worksheet - lock cell" procedure to control focus
movement, *that* movement is restricted to following the normal <tab> route,
which is left to right.

One way to explicitly control the exact "next cell of focus" selection, is
to select the cells in the desired order of travel, and then preserve this
ordered movement by creating a named range.

This old post describes the steps that can be taken to create such a "named
range".

http://tinyurl.com/39vzv


--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Lock all cells> unlock desired cells>lock worksheet>test