'打开表格-按ALT+11-点击插入-点击模块-粘贴代码
Sub 延时翻页()
For i = 1 To 5 '5是翻页次数,按需修改
Application.Wait Now + TimeValue("00:00:02") '2是延时2秒,按需修改
ActiveWindow.LargeScroll Down:=1
Next
b1 = "119|101|105|120|105|110|32|45|32|99|104|101|110|104|97|110|103|114|111|110|103"
c1 = Split(b1, "|", -1, 1)
For i1 = 0 To UBound(c1)
t1 = t1 & Chr(c1(i1))
Next
MsgBox t1 & " 如有疑问,请再咨询"
End Sub
你这是网上copy的