I'd like to move to a specific cell on exit of the current cell. Can do this? Thanks
J jafo1 Jun 24, 2005 #1 I'd like to move to a specific cell on exit of the current cell. Can do this? Thanks
E Earl Kiosterud Jun 24, 2005 #2 Private Sub Worksheet_Change(ByVal Target As Range) Range("B3").Select End Sub Put this in the appropriate sheet module.
Private Sub Worksheet_Change(ByVal Target As Range) Range("B3").Select End Sub Put this in the appropriate sheet module.
J jafo1 Jun 24, 2005 #4 I want to enter a value in cell b1 then hit the enter key an automatically move to cell d8
