Something has to trigger Excel to evaluate G10=G160 and
then select J160 if it is TRUE. What will trigger it? One
possibility is a Worksheet_Change event so that if cells
G10 or G160 are changed by the user, the macro will fire.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("G10,G160")) _
Is Nothing Then
If Me.[G10].Value = [G160].Value Then
Me.[J160].Select
End If
End If
End Sub
---
To use, right-click on the worksheet tab and choose "View
Code". Paste in the code above and press ALT+Q to close
VBE.
HTH
Jason
Atlanta, GA
