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