| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab Stop Order
I have exactly the saem question as Tdalhman yesterday!
I've created a form where I would like to select the order of the cells when users tab to the next question, ie to go down then across or whatever, rather than keep with the default of across. Can anyone help? -- morrisli |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tab Stop Order
try this
http://www.vbaexpress.com/kb/getarticle.php?kb_id=209 "morrisli" wrote: I have exactly the saem question as Tdalhman yesterday! I've created a form where I would like to select the order of the cells when users tab to the next question, ie to go down then across or whatever, rather than keep with the default of across. Can anyone help? -- morrisli |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tab Stop Order
Mike,
Many thanks - I'll give this a try. I knew it would be a macro of some sort but didn't know where to start. Linda -- morrisli "Mike" wrote: try this http://www.vbaexpress.com/kb/getarticle.php?kb_id=209 "morrisli" wrote: I have exactly the saem question as Tdalhman yesterday! I've created a form where I would like to select the order of the cells when users tab to the next question, ie to go down then across or whatever, rather than keep with the default of across. Can anyone help? -- morrisli |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tab Stop Order
Another way is to protect all the cells on the sheet except where you want
the users to enter data. Pressing tab will then jump to the next unprotected cell. "morrisli" wrote: Mike, Many thanks - I'll give this a try. I knew it would be a macro of some sort but didn't know where to start. Linda -- morrisli "Mike" wrote: try this http://www.vbaexpress.com/kb/getarticle.php?kb_id=209 "morrisli" wrote: I have exactly the saem question as Tdalhman yesterday! I've created a form where I would like to select the order of the cells when users tab to the next question, ie to go down then across or whatever, rather than keep with the default of across. Can anyone help? -- morrisli |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tab Stop Order
I have copied the code and it does not work still.
I do not even understand what the code is actually tyring to say there. Can you give me a possible breakdown of what is going on? "Mike" wrote: try this http://www.vbaexpress.com/kb/getarticle.php?kb_id=209 "morrisli" wrote: I have exactly the saem question as Tdalhman yesterday! I've created a form where I would like to select the order of the cells when users tab to the next question, ie to go down then across or whatever, rather than keep with the default of across. Can anyone help? -- morrisli |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tab Stop Order
Mike,
Your first solution is working partially so I'll need to have another look at it. Just protecting the cells doesn't work as the left-to-right default still operates, and I want the order to sometimes go down, then across, then back again. Many thanks for your help. -- morrisli "Mike" wrote: Another way is to protect all the cells on the sheet except where you want the users to enter data. Pressing tab will then jump to the next unprotected cell. "morrisli" wrote: Mike, Many thanks - I'll give this a try. I knew it would be a macro of some sort but didn't know where to start. Linda -- morrisli "Mike" wrote: try this http://www.vbaexpress.com/kb/getarticle.php?kb_id=209 "morrisli" wrote: I have exactly the saem question as Tdalhman yesterday! I've created a form where I would like to select the order of the cells when users tab to the next question, ie to go down then across or whatever, rather than keep with the default of across. Can anyone help? -- morrisli |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tab Stop Order | Excel Discussion (Misc queries) | |||
| PivotCharts and series order | Charts and Charting in Excel | |||
| To Stop or Not to Stop | Excel Discussion (Misc queries) | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
Linear Mode
