诗涵 发表于:2013-06-20 09:02:05
Dim Arr()
Randomize
S = "0123456789"
ReDim Arr(1 To Len(S))
For i = 1 To Len(S)
Arr(i) = Mid(S, i, 1)
Next i
For i = 1 To 5
For J = 1 To 5
S1 = ""
For L = 1 To 30
If L = 1 Then
S1 = "'" & Arr(Int(Rnd * 5 + 5))
Else
S1 = S1 & Arr(Int(Rnd * Len(S) + 1))
End If
If (L Mod 5) = 0 Then S1 = S1 & " "
Next L
Cells(i, J) = S1
Next J
Next i
Dim Arr()
Dim i As Long
Dim l As Long
Randomize
s = "0123456789"
ReDim Arr(1 To Len(s))
For i = 1 To Len(s)
Arr(i) = Mid(s, i, 1)
Next i
For i = 1 To 5
S1 = ""
For l = 1 To 20
If l = 1 Then
S1 = "'" & Arr(Int(Rnd * 5 + 5))
Else
S1 = S1 & Arr(Int(Rnd * Len(s) + 1))
End If
If (l Mod 5) = 0 Then S1 = S1 & " "
Next l
Next i
Forms![窗体名]!字段名 = S1
总记录:2篇 页次:1/1 9 1 :