Thread: data validation
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
choice choice is offline
external usenet poster
 
Posts: 18
Default data validation

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 functio

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