Macro to look for value that triggers after any change has been made

[MrMyagiii]

Hi,

I`m using the following code in sheet1 of my workbook to look if the word "TEST" is in range N10:N15. If so i want to display a message

Please Login or Register  to view this content.

However this doesn`t work since it also finds the formula that contains the "TEST" as a result. How can i search for the result of a formula instead of the formula itself?

[ikboy]

Please Login or Register  to view this content.

[MrMyagiii]

yes just like that! thnx

[ikboy]

Your code is no problem. If it not work again, try to reset Application.EnableEvents = True