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.

On Jul 5, 11:17*am, Sandman wrote:
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.


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

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

On Sat, 5 Jul 2008 08:17:00 -0700, Sandman
wrote:

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.