How do I set up top to bottom movement for a Form with two column

T

Teresa

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?
 
J

JLatham

Tools | Options | [Edit] tab - check out the option labeled "Move Selection
After Enter ... Direction" - it has options, one of which is Down!
 
T

Teresa

Thanks JL. I already tried that and it does in fact go to the line below. The
problem is that There is a space(s) between each 'answer' field and I would
like to jump a line or so to go directly to the next field for data entry.
Any suggestions for that?

JLatham said:
Tools | Options | [Edit] tab - check out the option labeled "Move Selection
After Enter ... Direction" - it has options, one of which is Down!

Teresa said:
I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?
Click to expand...
Click to expand...
 
G

Gord Dibben

Can you live with sheet protection?

Select the range for users to enter data.......say A1:B20

Format>Cells>Protection>Uncheck "locked" options.

Tools>Protection>Protect Sheet>Uncheck "select locked cells" and OK

With ENTER key set to move down start entering in A1.

Alternative is to use a named range.

Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then
A1 last

Insert>Name>Define. Give your range a name like MyRange

In Nmaebox select MyRange and start typing and ENTERing


Gord Dibben MS Excel MVP
 
T

Teresa

I do have the sheet protection on. I will try the rest of it and let you
know. Thanks
 
J

JLatham

It should work if set up the way Gord Dibben has instructed. That's about
the only way I know to skip cells without resorting to VB code (or clicking
with a mouse or entering directly into the Name Box - I mention those to keep
others from reminding me that those options exist).
 
T

Teresa

Ok guys. I did work...BUT, now it has decided to skip over one of the cells.
It is a 'drop list' created through the validation. I have others in the form
and they are woking fine. It just skips right over it. I can tab to it, but
not enter. Help? Any further suggestions? (other than 'give it up')
 
G

Gord Dibben

A contradiction here in my mind.............

"skips right over it" and "I can Tab to it but not enter".

Which is it?

What happens when you try to enter? A DV drop-down list should throw an error
if you try to enter something not on the list.


Gord
 
T

Teresa

If I try and use the enter key it goes from A1 to A3. If I use the tab button
it will go to A1, A2, and A3 etc. The enter key will go past the A2 field.
There is a list I created (with the validation option) that is in the A2
field. I can select it manually, tab to it, but not enter to that field. I
have other fields further down the form that are set up the exact same way
and they are fine. I can enter to those. Could this be and "I-D-10-T" error.
Am I missing something? Sorry for my frustration and incomplete descriptions.
 
G

Gord Dibben

What is the exact range you are concerned about and what order do you want to
have for that range?

Which method from my first post are you attempting to employ?

The "protection" method or the "named range" method?

Re-read the original post and try again with either method.

If using the protection method don't forget, when protecting the sheet, to
uncheck "select locked cells" so you can Tab or ENTER to locked cells only.


Gord
 
Top