Set Tab Sequence

[Herman Merman]

I have a data input form that I want users to be able to tab through th
required fields in a particular order. I know this is possible in a
Access form but can't find anything to do the same thing in Excel.

Any ideas? Thanks

 

[Ragdyer]

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!
==============================================

 

[David McRitchie]

that thread also mentioned use of protected cells and hidden cells.

Another way would be an Event macro allowing you to TAB so far
and then continue on the next row.

Worksheet_SelectionChange (#ws_sc)
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

Getting an answer best suited to your own situation is dependent on
more specific information as to what kind of pattern you actually need to use.


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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!
==============================================