Hi,
i found this code on the net and have tried in a trail workbook
when i physicall type "Project123" in a Column D cell is triggers the pop up as hoped...
... however if i use a formula in column D that still returns a value of "Project123" it does not trigger the popup
Using the below code
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("D
")) Is Nothing Then Exit Sub
If Target.Value <> "Project123" Then Exit Sub
MsgBox "You have entered Project123 into cell " & Target.Address
End Sub
original website http://answers.microsoft.com/en-us/...62?msgId=4fd0be14-0b3b-4c3c-bad5-f830307b584c
View attachment pop up test.zip
i found this code on the net and have tried in a trail workbook
when i physicall type "Project123" in a Column D cell is triggers the pop up as hoped...
... however if i use a formula in column D that still returns a value of "Project123" it does not trigger the popup
Using the below code
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("D
")) Is Nothing Then Exit SubIf Target.Value <> "Project123" Then Exit Sub
MsgBox "You have entered Project123 into cell " & Target.Address
End Sub
original website http://answers.microsoft.com/en-us/...62?msgId=4fd0be14-0b3b-4c3c-bad5-f830307b584c
View attachment pop up test.zip