1.需求:进行学生点名
2.代码:
Sub 随机点名()
Dim rng As Range
Set rng = Range("B:B").Find("姓名")
start_row = rng(2, 1).Row
end_row = rng.End(xlDown).Row
i = Int(Rnd * (end_row - start_row + 1))
If i < 1 Then
rng(3, 3) = "轮空"
Else
rng(3, 3) = Cells(i, 2)
ssr = "请" & rng(3, 3).Value & "同学回答问题"
Application.Speech.Speak ssr
End If
End Sub
Private Sub 开始_Click()
Call 随机点名
End Sub