when creating a form within excel 2002 can you set a tab index to move to the
relevant fields.

Just worksheet cell selections?

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, post back for more detail and some sample code.


Gord Dibben Excel MVP

On Mon, 12 Sep 2005 14:57:01 -0700, "thewelshman"
wrote:

when creating a form within excel 2002 can you set a tab index to move to the
relevant fields.

Thanks for the advise I will give it ago

"Gord Dibben" wrote:

Just worksheet cell selections?

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, post back for more detail and some sample code.


Gord Dibben Excel MVP

On Mon, 12 Sep 2005 14:57:01 -0700, "thewelshman"
wrote:

when creating a form within excel 2002 can you set a tab index to move to the
relevant fields.