|
这是代码
Private Sub Worksheet_Change(ByVal Target As Range)
Dim i, j, arr, row, r, c, t
r = Target.row
c = Target.Column
With Sheets("单词")
row = .Cells(Rows.Count, 1).End(3).row
arr = .Range("A2:D" & row)
If c = 7 And .Cells(r, c - 1) <> "" Then
For i = 1 To UBound(arr)
If .Cells(r, c - 1) = arr(i, 1) And .Cells(r, c) = arr(i, 4) Then
.Cells(r, c + 1) = "√"
t = .Cells(10, "K")
For j = 1 To t
Application.Speech.Speak (.Cells(r, c - 1))
Application.Speech.Speak (.Cells(r, c))
Next
Exit For
End If
Next
End If
End With
End Sub |
|