Tabbing to select fields

[Confused]

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]

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]

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

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