有这样一段代码:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim x%
For x = 1 To 10
Cells(x, 1) = x
Next x
End Sub
如果在第一次x=1循环后,间隔2秒再循环x=2,间隔2秒再循环x=3,依次类推该怎样做?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim x%
For x = 1 To 10
Cells(x, 1) = x
Application.Wait (Now + TimeValue("0:00:10"))
Next x
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim x%
For x = 1 To 10
Cells(x, 1) = x
Application.Wait (Now + TimeValue("0:00:10"))
Next x
End Sub