Where did you put that macro ? its supposed to go in the 'Sale' sheet code
module, especifically in the Change event.

--
Regards,

Juan Pablo González

"choice" wrote in message
...
i have a list on Tracking!C4:C1000 (not sorted), i want when someone
enters a number in Sale!P2 a box to pop up if Sale!P2 is not in
Tracking!C4:C1000, the box will have 2 options yes or no, yes will run macro
"SortTracker", no will not do anything.

This is what i put in but nothing seems to be working, im not sure if i am
supposed to change anything with the worksheet function

Dim ans
If WorksheetFunction.CountIf(Range("Tracking!C4:C1000 "),
Range("Sale!P2")) 0 Then
ans = MsgBox("Please Enter in Tracker", vbYesNo)
If ans = vbYes Then SortTracker
End If