Worksheet Change Event on a Data Validation List

[Cbluum7]

I have a Worksheet Change Event that is suppose to fire when the user selects a item from the validation list. It has worked up till now and the reason is I have created a conditional format on the sheet with a User Defined Function within it. I do not know why but it does not work because of the conditional format UDF but will if i take the UDF out of the conditional format. The Worksheet Change Event will fire if i type the item i want in but not when selecting from the list.

I have tried adding Application.EnableEvents within the Function but it still does not work. I have the application.EnableEvents within the Worksheet Change event too.

Any ideas?

 

[Cbluum7]

I managed to get this to work for anybody who is interested. I added a Worksheet_Calculate Event and called the Worksheet_Change Event from there (See Below).

Private Sub Worksheet_Calculate()

Worksheet_change Range("A3")

End Sub

Private Sub Worksheet_change(ByVal Target As Range)

If Not Intersect(Target, Range("A3")) Is Nothing Then
'Code Here
End if
End Sub