Tabbing to select fields

Confused · May 10, 2008

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

Gord Dibben · May 10, 2008

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

Confused · May 12, 2008

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

Gord Dibben said:
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