|
发表于 2016-6-16 11:15
|
显示全部楼层
本楼为最佳答案
- Sub 计时()
- If b = True Then
- Application.OnTime Now + TimeValue("00:00:01"), "计时"
- Sheet1.[L12] = Time
- For i = 2 To 7
- If Sheet1.[L12] < arr(2, x) Then
- Sheet1.[L10] = ""
- Sheet1.[L11] = arr(2, 1)
- End If
- If arr(i, x) = Sheet1.[L12] Then
- Mp3name = ThisWorkbook.Path & "" & arr(i, 1) & ".mp3"
- MPlay (Mp3name)
- Sheet1.[L10] = arr(i, 1)
- If i < 7 Then
- Sheet1.[L11] = arr(i + 1, 1)
- Else
- Sheet1.[L10] = ""
- End If
- t = arr(i, x) + TimeValue("00:00:10") '音乐播放20秒
- End If
- Next
- If t = Time Then MStop (Mp3name)
- End If
- End Sub
复制代码 |
|