Excel Sorting

Comparing Strings in VBA (after they have been sorted in Excel) does not work.
The ASCII code associated with the characters for VBA is not consistent with how Excel sorts a text sting on the worksheet.