"Tab Order for Specific Fields"

[Bernardo Zavala]

Is there a way to select specific fields, that once an
item is entered in that specific field it would select a
another specific field? I hope this make sense.
Thanks

 

[David McRitchie]

Hi Bernardo,
You can affect the way the tab key works by
- Preselecting your range (single or multiple areas) of cells
- Protecting cells you don't want the user to move to
- Event Change macro
Worksheet_SelectionChange to prevent entry in certain columns (#ws_sc2)
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc2

 

[Myrna Larson]

You could do this with an event macro. But if there are many of these, maybe you should think in
terms of using a data entry form, either the built-in one, or a custom form.

 

[Nick Hodge]

Bernardo

If you unlock the cells they will be selected with the tab key. Remember
protection is a two-stage process in XL. Highlight the cells to unlock
(Ctrl+Click), go to Format>cells.Protection and uncheck 'locked' now protect
the sheet Tools>protection>protect sheet...

Now if you press tab it will iterate only on the unlocked cells. (And enter
for that matter)

 

[Dave Peterson]

And if you kind of like what you find under Data|Form, you may be ecstatic with
John Walkenbach's enhanced version:

http://j-walk.com/ss/dataform/index.htm

You can purchase the password for the code for $20 (USA).