Cursor Movement Problem

[Minitman]

Greetings,

I need for the user to be able to hit the enter key and
the cursor to jump to the next data entry cell (which is
not touching the entry cell where the cursor is now
sitting). This is for a single sheet with 114 entry cells.

Can someone please show me how this is done or point me in the
right direction.

TIA

-Steve Moulton

 

[Earl Kiosterud]

Steve,

Go into the Visual Basic Environment (Alt-F11) and select your sheet in the
VBAProject window (if it isn't there, View - Project Explorer). Open the
Properties window (View - Properties window), and set property
EnableSelection to xlUnlockedCells.
Now back in Excel (Alt-Tab), unlock the cells that you'll be using (Format,
Cells, Protection). The rest will remain lockes (which they all were by
default). Then protect the sheet (Tools, Protection).

 

[Minitman]

Hey Earl,

Thanks. That answered the major part of the problem, there remains a
need for tweaking the solution a bit. Is there anyway that I can
control the order in which the cursor moves instead of the default
order (right until end of row then beginning of the next row down,
within the unprotected range). I have one large merged cell that
overlaps several rows and the cursor got stuck in a loop because of
it.

Having control of the tab order would solve these problems.

Any suggestions on refining this technique.

TIA

 

[Earl Kiosterud]

Steve,

You can't control the order of cell movement directly, unless you write a
macro using the Selection_Change event.

Try to avoid merged cells. They're generally trouble, and it shows up later
when you don't realize that the merged cell is what's causing a problem.