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

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

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

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


On Fri, 26 May 2006 11:43:06 -0700, PE wrote:

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