How do I exclude a value in data validation?

K

Kindred Spirit

I want to exclude a value that I want visible in my data validation list. I
want it visible to show organization in a long list, but I don't want the
heading to be an allowable value. Help.
 
L

L. Howard Kittle

How about a change event macro.

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("F1").Value = "Your Value" Then Range("F1").Value = ""
End Sub

HTH
Regards,
Howard
 
Top