How do I set the tab stops in a specific cell pattern?

[Guest]

I am creating a data entry form where some of the cells will not be used,
therefore am looking for help on setting the tab stops in a sequecial order
at which the form will be used.

Can anyone help?

Thank you

 

[Gord Dibben]

PE

There are several ways to set the TAB order on worksheet cells.

See Bob Phillips' site for methods.

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

There is another method using VBA event code.

If interested in the coding, post back for more detail and some sample code.


Gord Dibben Excel MVP

I am creating a data entry form where some of the cells will not be used,
therefore am looking for help on setting the tab stops in a sequecial order
at which the form will be used.

Can anyone help?

Thank you

Gord Dibben MS Excel MVP