Private Sub Command1_Click()
MsgBox random
End Sub
Function random() As String
Dim temp As New Collection
Dim a(1 To 20) As String
Dim i As Integer, num As Integer
For i = 1 To 10
temp.Add i
temp.Add i
Next
Randomize
For i = 1 To 20
num = Int(Rnd * temp.Count + 1)
a(i) = temp(num)
temp.Remove num
Next
random = Join(a(), ",")
End Function