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