| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
| Since SP2, my pivot tables cannot select various fields | Excel Discussion (Misc queries) | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Tabbing through form fields | Excel Discussion (Misc queries) | |||
| Tabbing between fields (not cells) | Excel Discussion (Misc queries) | |||
Linear Mode
