Message Box based on cell value containing formula

Hi Friends,

I have a formula in cell B65 (=COUNTIF(B45:B64,TRUE)). If the total sum in cell B65 is more then 2, then a message box has to appear. Given below is my code and it does not work in cell B65 as it contain formula. But when I remove formula and manually type(in cell B65) 2,3,4 .... the message box appear. Let me know if I am doing something wrong.

Private Sub Worksheet_Change(ByVal Target As Range)

Set Target = Me.Range("B65")

If Target.Value > 2 Then
MsgBox "You exceeded 2"
End If


End Sub

Thanks,
Rahul