if a user selects a value from a data validation list the VBA code is not
executing, how do i fix this?

i have something similar. mine is in c2, this may work

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count = 1 Then
If Not Intersect(Target, Range("C2")) Is Nothing Then
Call Threshold

Else
'Exit Sub

End If
End If
End Sub

--


Gary


"ivory_kitten" <(E-Mail Removed)> wrote in message
news:50F186EC-79FD-4A25-B4B1-(E-Mail Removed)...
> if a user selects a value from a data validation list the VBA code is not
> executing, how do i fix this?