Cell Navigation

[jimw00d]

I am a super newbie when it comes to vbscript so bear with me.

I am trying to use either a macro or some script to activate a given cell using the MoveAfterReturn function.

When I enter a value in B11 and hit enter on the keyboard, I want the next active cell to be C6.

So far I have:

Public Sub Workbook_Activate()
Range("B11").Select
MoveAfterReturn = True
Application.Goto Reference:=Worksheets("VERBS-REG").Range("c6")
 
End Sub

This works if I run the script in MVB, but not if I hit enter.

Any help would be great.






Edit: Added [vbcode][/vbcode] tags. - Hack

[Hack]

Excel question moved to Office Development.

[DKenny]

Jim
Copy the attached into the code page for the "VERBS-REG" worksheet.

This code will execute every time a change is made to that worksheet, when the change is made in cell B19 it will then select cell C6.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$19" Then Range("C6").Select
End Sub

[jimw00d]

That works a treat. Thanks very much.