String Comparison Not Working

This should be as simple as can be, but for some reason it's not working and I can't figure out why:

I have a string called LastSWApplication. I have a test like the following against it:

Please Login or Register  to view this content.

I've put it under testing and LastSWApplication is clearly equal to "Microsoft Office 2007 Professional", no ending spaces or the like, and the length is 34 characters.
It never matches. I backed up under testing with breakpoints and if I change the check to just before the number 2 it works fine and sets ImportantApplication to Y. The check would then look like this:

Please Login or Register  to view this content.

If I simply add the 2 back on both sides of the equation it doesn't match.
I have other checks like the following and they fail too:

Please Login or Register  to view this content.

As crazy as this sounds, it's almost as if "Microsoft Office numeric" is some special type of text. I've never had something like this in VBA but maybe I'm missing something easy. Any ideas?

Hi js0873,

Please use code tags when posting code.

In theory it makes no sense... but what type of variable is LastSWApplication? How is it's value assigned?
I assigned the string the value and performed the test, which matches.

Have you tried

Please Login or Register  to view this content.

Otherwise I suggest you upload the workbook so that we can check in context.

I assume you have checked the LastWSApplication value after you assign it?

Then I have no logical explanation, as Richard said, maybe with the (cleansed) workbook we can do more.

The test in the OP is case sensitive. Is that a possible source for the error?

Your code checks for:
"Microsoft Office 2007 Professional"
your worksheet data does not contain this... it flips the "Professional" and "2007":
"Microsoft Office Professional 2007"
That is row 7 of the Installed Applications sheet, column C. Column A contains a match, but your checking is based on C, not A.
Thus there is no match.

Near the top on the right, there is an item called "Thread Tools", it should have an option "Mark as Solved"

Hopefully that means your issue is resolved?

Judging by the fact that you were kind enough to give rep points, I assume so. Thanks for that

My pleasure! Sorry my last post was a bit stupid... missed your previous post...