How can you set up a form that the cursor only moves to cells tha.

[Guest]

I have set up a form. Now I want my cusor to move through the worksheet
only in certain cells. I want to be able to go from one cell that needs to
be filled out to the next cell that needs to be filled out automatically.
Example , move from cell a3 to c19 automatically. How can I do that?

 

[Biff]

Hi!

You can accomplish that by setting sheet protection.

Select all the cells that you want to be able to navigate
to then goto Format>Cells>Protection tab. Uncheck Locked.

Now, goto Tools>Protection>Protect sheet. A list of
options will appear. Uncheck Select locked cells and check
Select unlocked cells.

Now you will be able to navigate to only those cells which
are unlocked. The navigation sequence will be from left to
right then down, left to right etc. In other words you
can't go from A1 to A4 then to B1. the sequence will be
A1,B1,A4.

Biff

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0008.html

--
Regards
Frank Kabel
Frankfurt, Germany

I have set up a form. Now I want my cusor to move through the worksheet
only in certain cells. I want to be able to go from one cell that needs to
be filled out to the next cell that needs to be filled out automatically.
Example , move from cell a3 to c19 automatically. How can I do

that?

 

[Gord Dibben]

In addition to the methods used at the URL Frank provided

There is a third method which requires VBA and a Worksheet_Change event.

''moves from C2 through E5 at entry
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
'and on and on.....
End Select
End Sub

Gord Dibben Excel MVP