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?