数组只能 逐个值比较 ,
Sub add()
Dim ar(1), br(1), i As Integer
ar(0) = 123: ar(1) = 456
br(0) = 123: br(1) = 456
For i = LBound(ar) To UBound(ar)
If ar(i) <> br(i) Then
MsgBox "数组不同"
Exit Sub
End If
Next i
MsgBox "数组相同"
End Sub
========================================
但一维数组 可以 用join 转为文本
Sub add2()
Dim ar(1), br(1), i As Integer, ar文本 As String, br文本 As String
ar(0) = 123: ar(1) = 456
br(0) = 123: br(1) = 456
ar文本 = Join(ar, "◆")
br文本 = Join(br, "◆")
If ar文本 = br文本 Then
MsgBox "数组相同"
Else
MsgBox "数组不同"
End If
End Sub