【方法一】

StrComp(string1, String2, [Compare])

'函数功能：比较字符串string1和string2。

'返回说明：返回整数值：当string1string2时，返回值>0。这种比较是按照字符的字典序进行比较。

【方法二】

Declare Function lstrcmp Lib "kernel32" Alias "lstrcmpA" (ByVal lpString1 As String, ByVal lpString2 As String) As Long

'或者用API的lstrcmp也能很快地实现字符串的对比

【方法三】

'By JiaJia 2008-05-30
Private Function MyStrCmp(str1 As String, str2 As String) As String
Dim TmpFor As Long, Log As Long
Dim Len1 As Long, Len2 As Long
If Len1 <> Len2 Then '长度不等直接退出
If Instr(str1, str2) > 0 Or Instr(str2, str1) > 0 Then
MyStrCmp = "长度不同，有匹配字符存在。"
Else
MyStrCmp = "完全不同。"
End If
Exit Function
ElseIf Len1 = Len2 Then
For TmpFor = 1 To Len1
If Mid(str1, TmpFor, 1) <> Mid(str2, TmpFor, 1) Then Log = Log + 1
Next
If Log = 0 Then
MyStrCmp = "长度相同，有 " & Log & " 个字符不同。"
Else
MyStrCmp = "完全相同。"
End If
Exit Function
End If
End Function