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

P

PE

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
 
G

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
Click to expand...

Gord Dibben MS Excel MVP
 
Top