Thread: Move cell focus in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Move cell focus in VBA
some like this !

Private Sub Worksheet_Change(ByVal Target As Range)

If [E6] = "Yes" Then [I6].Select
If [I6] = "No" Then [L6].Select

End Sub

Reply With QuoteReply With Quote