Sub Test() Dim K%, i%, j% Dim strA$ strA = "好好学习天天向上" [A1:B4].ClearContents For j = 1 To 2 For i = 1 To 4 K = K + 1 Cells(i, j) = Mid(strA, K, 1) Application.Wait Now + TimeValue("0:00:01") Next i Next j End Sub
Sub DlyWrt() Const Str AsString = "asdfqwer" Dim OneS AsString Dim Lnth AsInteger Dim i AsInteger Rows(1).ClearContents For i = 1 To Len(Str) delay (1) Cells(1, i) = Mid(Str, i, 1) Next i EndSub
Sub delay(T AsSingle) Dim T1 AsSingle T1 = Timer Do DoEvents LoopWhile Timer - T1 < T EndSub
Sub Test() Dim K%, i%, j% Dim strA$ strA = "好好学习天天向上" [A1:B4].ClearContents For j = 1 To 2 For i = 1 To 4 K = K + 1 Cells(i, j) = Mid(strA, K, 1) Application.Wait Now + TimeValue("0:00:01") Next i Next j End Sub