Here's how to do it:

1. Display the VB editor
2. In the window on the left margin, find VBAProject(Your Filename)
3. Right click the relevant tab name
4. Select View Code
5. On the main window, change the dropdown from (General) to Worksheet
6. Paste in the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$2" Then Range("B10").Select
End Sub

This code causes the cell pointer to move to B10 when the value in A2
in changed. You'll probably need to change those cell addresses-
please note that the $ are required.

Hope this does it for you!