|
本帖最后由 france723 于 2017-5-9 17:36 编辑
资料上说,VBA使用sleep函数需要特别声明, 请教各位大神.
比如单元格[A1]是一个数据源, 数值自动变化, 每隔两秒提取[A1]数值, 写入B列.
我常用test3,不需要声明引用
- Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
- Sub test1()
- Do While True
- Debug.Print [A1]
- Sleep 2000
- DoEvents
- Loop
- End Sub
- Sub test2()
- Do While True
- Debug.Print [A1]
- Application.Wait (Now + TimeValue("00:00:02"))
- DoEvents
- Loop
- End Sub
- Sub test3()
- 1:
- t = Timer
- Do While Timer < t + 2
- DoEvents
- Loop
- Debug.Print [A1]
- GoTo 1
- End Sub
复制代码
|
|