Macro to Check if Cells Contain Matching Text

I am trying to compare cell values for data validation.
One of the cells is a column header in a pivot table, and the other is just a cell. Each contains a word, and should be the same.

I tried using this code

Please Login or Register  to view this content.

But I always get the error message, even if I know the cells match. I've also tried dimensioning the cells as integers.
Why won't Excel recognize they equal the same thing?

Thank you in advance!

If they are words (string) declaring them as Integers isn't going to work. With that being said, why even declare them at all? Try:

Please Login or Register  to view this content.

Ahh yes that is better

beautiful!! thank you so much!
And now I've learned something new =)