run macro whenever any cell is changed

[bob engler]

I have a Validate macro in a spreadsheet that checks several fields whenever
the Validate macro button
is clicked. Is there a way to call that macro any time any cell in the sheet
is changed or selected. The
clerks can't seem to click the button when they access the sheet. One of the
import validation checks it
does is check the Contact time for all rows which alerts us if a Tech hasn't
touched base with us within
the last 2 hours if his job is still open.

Thanks in advance...

 

[Guest]

Put your macro in the sheet module as a Worksheet_Change procedure by right
clicking the sheet tab>ViewCode. Click the window that says General, then
click worksheet. That should load the declarations window from which you can
select "Change" and that should then enter the following in the code module:

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

Enter your code between the two lines.