|
本人VBA不是太精通,请求各位大神帮完善下一个测试监控系统,谢谢,要求如下。当扫完条码后 对应条码开始计时 ,
经过设定的时间段后时间停止,并把对应条码的结束时间录入到表格结束时间栏,
对应条码表格颜色为红色,同时弹出提示框提示:哪个槽位的哪个条码已经测试OK.
- Option Explicit
- Public rgs As Range, i%
- Sub 刷新()
- Dim rg As Range
- Set rg = Sheet1.Range("e" & Cells.Rows.Count).End(xlUp)
- If rg.Row < 3 Then End
- Set rgs = Sheet1.Range(Sheet1.Range("a3"), rg)
- i = rgs.Rows.Count
- 时间
- End Sub
- Sub 时间()
- Dim t1 As Date
- Dim k%, kk%
- With rgs
- For k = 1 To i
- If .Cells(k, 3) = "" Then
- kk = kk + 1
- If .Cells(k, 2).Value + .Cells(k, 5).Value < Now Then
- .Cells(k, 3).Value = Now
- End If
- End If
- Next k
- End With
- If kk = 0 Then End
- DoEvents
- Application.OnTime Now() + TimeValue("00:00:01"), "时间"
- End Sub
复制代码在模块中加上主面语句后,并同时需要在Private Sub CommandButton1_Click()事件中也加入“CALL 刷新”语句。
|
|