Tab Stop Order

morrisli · External Since: Jan 23, 2007 Posts: 4

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

Mike · External Since: Mar 10, 2006 Posts: 1301

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

morrisli · External Since: Jan 23, 2007 Posts: 4

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

Mike · External Since: Mar 10, 2006 Posts: 1301

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

Tdahlman · External Since: Jan 22, 2007 Posts: 5

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

morrisli · External Since: Jan 23, 2007 Posts: 4

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