Right click on the tab of the sheet that you would like to react to a change.
Select View Code. Thiw will open up the
VB editor. Just above the code window
is a drop down list that will say General. Switch it to Worksheet. When you
do this a procedure will be added to the code window that is on selection
change (not what you want so just delete it). Jut to the right of the drop
down that now says worksheet is a drop down. Select change. A change
procedure has now been added similar to
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
Add a message box to it something like this...
Private Sub Worksheet_Change(ByVal Target As Range)
msgbox "You changed " & target.address & " to " & target.value
End Sub
--
HTH...
Jim Thomlinson
"rafik" wrote:
can you please show me how to run a macro after a change a cell
thank you in advance