|
A02-guofei0344_
本帖最后由 guofei0344 于 2015-11-16 16:30 编辑
- Public Function 判断(a As String, b As String)
- Dim arr1, arr2, i As Byte, j As Byte, k As Byte
- arr1 = VBA.Split(a, ",")
- arr2 = VBA.Split(b, ",")
- If a = b Then 判断 = "相同": Exit Function
- If VBA.Len(a) <> VBA.Len(b) Or UBound(arr1) <> UBound(arr2) Then 判断 = "不相同": Exit Function
- For i = 0 To UBound(arr1)
- For j = 0 To UBound(arr2)
- If arr1(i) = arr2(j) Then
- k = k + 1
- arr2(j) = ""
- Exit For
- End If
- Next
- Next
- If k = UBound(arr1) + 1 Then
- 判断 = "相同"
- Else
- 判断 = "不相同"
- End If
- End Function
复制代码 |
评分
-
查看全部评分
|