Auto Update in excel
 

I need to know how to have my validation macro run everytime i change
the contents of a cell. I've tried putting the macro name in the
Worksheet_Change Source but it seems to be stuck in a loop. Any help?

Auto Update in excel
 

Try This, just change the address between the quotes to suit your
needs.

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo DoNothing
If Target.Address = "$A$1" Then
MsgBox "This works"
End If
Exit Sub

DoNothing:

End Sub


This will avoid running into a continuos loop

Auto Update in excel
 

before the end of your macro,
a1=11 or something


€�编写：

I need to know how to have my validation macro run everytime i change
the contents of a cell. I've tried putting the macro name in the
Worksheet_Change Source but it seems to be stuck in a loop. Any help?