Tabbing to select fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Confused - 10 May 2008 13:47 GMT

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

Reply to this Message

Gord Dibben - 10 May 2008 19:27 GMT

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

>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

Reply to this Message

Confused - 12 May 2008 16:26 GMT

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

> See Bob Phillips' site for a couple of methods to set the Tab order.
>
[quoted text clipped - 11 lines]
> >
> >Confused

Reply to this Message