right click sheet tab>view code>left window select worksheet>right window
select worksheet_change
write code. You probably will want to restrict to a cell or range.

Dear all,

I need that excel execute some VBA code when I change the value of a
cell in a sheet...

How can I do it?

Thanks a lot !!!

André.

André,

Roger has given you the code to cause your code to run when a particular cell has been
changed.  If it's a range of cells, like an entire column, here's an oft-used technique:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect( Target, Range("A:A")) is Nothing then
   ' your code here
   End If
End Sub

Dear all,

I need that excel execute some VBA code when I change the value of a
cell in a sheet...

How can I do it?

Thanks a lot !!!

André.

Here's one I got from Mudraker awhile back that will run a different macro
depending on the value entered in A2

Private Sub Worksheet_Change(ByVal Target As Range)
'By Mudraker 3/26/06
If Target.Address = "$A$2" Then
Application.EnableEvents = False
Select Case Target.Value
Case "Purchase"
Call macroA
Case "Sales"
Call MacroB
End Select
End If
Application.EnableEvents = True
End Sub

Vaya con Dios,
Chuck, CABGx3