Move to a specific cell on exit of current

[jafo1]

I'd like to move to a specific cell on exit of the current cell. Can
do this?

Thanks

 

[Earl Kiosterud]

Private Sub Worksheet_Change(ByVal Target As Range)
Range("B3").Select
End Sub

Put this in the appropriate sheet module.

 

[zhy]

what do you mean "on exit of the current cell"?

 

[jafo1]

I want to enter a value in cell b1 then hit the enter key an
automatically move to cell d8