Dim coll As New Collection
Dim num As Long
Private Sub Command1_Click()
Dim avg As Double
avg = 0
Dim a(1 To 50) As String
For i = 1 To 50
a(i) = coll.Item(i)
avg = avg + Val(coll.Item(i))
Next
MsgBox "数据:" & Join(a(), ",") & vbCrLf & vbCrLf & "均值:" & avg / 50
End Sub
Private Sub Command2_Click()
num = num + 1
coll.Remove 1
coll.Add num
End Sub
Private Sub Form_Load()
For i = 1 To 50
coll.Add i
Next
num = 50
End Sub