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.
"Gord Dibben" wrote:
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
On Tue, 6 Mar 2007 06:26:40 -0800, Teresa
wrote:
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')
"JLatham" wrote:
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).
"Teresa" wrote:
I do have the sheet protection on. I will try the rest of it and let you
know. Thanks
"Gord Dibben" wrote:
Can you live with sheet protection?
Select the range for users to enter data.......say A1:B20
FormatCellsProtectionUncheck "locked" options.
ToolsProtectionProtect SheetUncheck "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
InsertNameDefine. Give your range a name like MyRange
In Nmaebox select MyRange and start typing and ENTERing
Gord Dibben MS Excel MVP
On Mon, 5 Mar 2007 09:32:11 -0800, Teresa
wrote:
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?