Luis,
The Worksheet_Change event which occurs every time you change something on a
worksheet, will do the job for you. Open the
VB editor, select the
particular worksheet in the project explorer and put in the following:
Private Sub Worksheet_Change(ByVal Target As Range)
'Your code
'...
'...
End Sub
HTH,
Nikos
"Luis" wrote in message
...
Hello.
I want to run some VBA code when a user changes one cell.
Is it possible to capture the change event on a cell, or
the afterupdate event and run a certain VBA code?
If so, how can i do this? Note, the cell in question can
be anyone on the worksheet.
Thanks.