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 <Sand...@discussions.microsoft.com> 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 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

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 <(E-Mail Removed)>
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.