Set Tab Sequence

  • Thread starter Thread starter Herman Merman
  • Start date Start date
H

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




Ragdyer said:
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!
==============================================
Click to expand...
 
Back
Top