macro on exit of field

[Manuel Murieta]

Is there a way to run a macro on exiting a cell. For example if I answer Yes
in cell A4, then I would like it to automatically go to A10 on exiting A4.

 

[merjet]

Put this in the appropriate Sheet Module.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$4" Then
If Target = "Yes" Then Range("A10").Select
End If
End Sub

Hth,
Merjet

 

[Guest]

You can use the on change code of the worksheet. Right click the sheet tab
and select View Code. I have made the code easy to expand and modify. Paste
the following...

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$A$4"
If UCase(Target.Value) = "YES" Then Range("A10").Select
Case "$A$10"
MsgBox "Change " & Target.Address
End Select
End Sub

 

[JE McGimpsey]

This was already answered in a previous post.

 

[Gord Dibben]

See responses to your same posting in public.excel news group.


Gord Dibben MS Excel MVP