Change Insertion Point

[Sandman]

How do I send cursor to new insertion point that is not an ajacent cell? In
completing a form I want the insertion point to go from B4 to A8 to D4 to C8
etc.

 

[recrit]

How do I send cursor to new insertion point that is not an ajacent cell?  In
completing a form I want the insertion point to go from B4 to A8 to D4 toC8
etc.

Range("A8").Select

depending on how you are triggering it you can set up different cases
for each cell to jump to...
example:

on Sheet1 object code:
Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.AddressLocal = "$B$4") Then
Range("A8").Select
End If
End Sub

 

[Gord Dibben]

See Bob Phillips' site for a couple of methods to set the Tab order.

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

There is also a VBA method using sheet event code if you want it.

Post back if so.


Gord Dibben MS Excel MVP