Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I specify the order...
in which data is entered into a form? I want the user to move from field to
field by using the Tab or Enter. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I specify the order...
hi
on the property sheet of each control you have on your form should be 2 properties you are interested in. TabIndex and TabStop. for each control you wish to tab to, set the TabStop to true. if you want to skip that control, set the TabStop to false. for the first control you wish to start in, set the TabIndex to 0. for the next control you wish to tab to, set the TabIndex to 1, set the next control's Tabindex to 2 and so on untill you have all the control in the order you wish to tab through. the TabIndex and TabStop properties are controled by the tab key but not the enter key. Regards FSt1 "JohnP" wrote: in which data is entered into a form? I want the user to move from field to field by using the Tab or Enter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cells down a column (in order) to across a row (same order?? | Excel Discussion (Misc queries) | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |