You have to put the macro in the Worksheet_Change event (in the specific
worksheeet's code module):

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range(SpecificCell)) Is Nothing Then
If Range(SpecficCell) = SpecificValue Then
'your macro steps
End If
End If
End Sub

--

Vasant


"j8f" wrote in message
...
I want a macro to run automaticaly when I enter a specific value in a
specific cell on a specific worksheet