Sub test()
Dim arr1, arr2, brr(1 To 100000, 1 To 1)
Dim i, j, k
arr1 = Sheets(1).Range("A1").CurrentRegion
arr2 = Sheets(2).Range("A1").CurrentRegion
For i = 1 To UBound(arr2)
For j = 1 To UBound(arr1)
If arr1(j, 1) = arr2(i, 1) Then
k = k + 1
brr(k, 1) = arr1(j, 2)
End If
Next
Next
Sheets(2).[b1].Resize(k, 1) = brr
End Sub
Private Sub CommandButton1_Click()
a = Sheet1.[a65536].End(xlUp).Row
For i = 1 To a
If ActiveCell.Value = Sheet1.Cells(i, 1) Then
Sheet2.Cells(ActiveCell.Row, 2) = Sheet1.Cells(i, 2)
End If
End Sub
Next
在sheet2中插入一个命令按钮,输入上述代码,同样可以实现查单词词义的功能,但速度比较慢。