if column A and column B on selected row are equal...

[wisewood]

I need to know how to check if column A and column B are equal on the selected row.

ie. if i am on row 221, i want to check that A221 and B221 are equal... and if they are, run MyMacro()... or if i am on row 9957585 then it checks to see if A9957585 = B9957585.

You get the point I'm sure.

I want to trigger it by exiting specific cells - but i already know how to do that.

 

[Lewiy]

Something like this perhaps:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(Target.Row, 1) = Cells(Target.Row, 2) Then
    'macro code here
End If
End Sub

 

[brian.wethington]

There are 2 types of events you might be looking for: Change Event or SelectionChange Event.

Private Sub Worksheet_Change(ByVal Target As Range)

Rw = Target.Row
If Cells(Rw, 1) = Cells(Rw, 2) Then
    'Enter your code
End If

End Sub

This would run every time you make a change in the sheet

Or this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Cells(Rw, 1) = Cells(Rw, 2) Then
    'Enter your code
End If

End Sub

would run every time you select a new cell. These actually check the row it just left. Adjustments could be made to change that if you need.