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

T

Thends

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?
 
B

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
 
F

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

Thends said:
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
Click to expand...
that?
 
G

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
 
Top