Use this event in the sheet module to do this

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("C2"), Target) Is Nothing Then
If IsNumeric(Target.Value) And Target.Value 0 Then
CUSTOMER
End If
End If
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"nowfal " wrote in message ...
Hi,

I wanted to run a macro based on cell value i.e., if i put in C2 a
number greater than zero it should trigger the macro named 'CUSTOMER',
if it is zero it should not . I am expecting a reply as early as
possible
thanks
nowfal


---
Message posted from http://www.ExcelForum.com/