Tabbing to select fields
 

I am setting up a form for multiple users to use, however I would like them
to be able to move through the form by tabbing or enter to select fields,
i.e. tab from cell a4 to g3 to h20, etc. Can this be done.

Confused

Tabbing to select fields
 

See Bob Phillips' site for a couple of methods to set the Tab order.

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

There is also a VBA method using sheet event code if you want it.

Post back if so.


Gord Dibben MS Excel MVP


On Sat, 10 May 2008 05:47:00 -0700, Confused
wrote:

I am setting up a form for multiple users to use, however I would like them
to be able to move through the form by tabbing or enter to select fields,
i.e. tab from cell a4 to g3 to h20, etc. Can this be done.

Confused

Tabbing to select fields
 

Worked great!!!! Thanks a bunch for your help.

"Gord Dibben" wrote:

See Bob Phillips' site for a couple of methods to set the Tab order.

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

There is also a VBA method using sheet event code if you want it.

Post back if so.


Gord Dibben MS Excel MVP


On Sat, 10 May 2008 05:47:00 -0700, Confused
wrote:

I am setting up a form for multiple users to use, however I would like them
to be able to move through the form by tabbing or enter to select fields,
i.e. tab from cell a4 to g3 to h20, etc. Can this be done.

Confused