Private Sub Command1_Click() Dim num As Single, x(2, 2) As Double, s As Variant s = Array(2, 7, 6, 9, 5, 1, 4, 3, 8) Randomize num = Format(Rnd * 100, "0.00") For i = 0 To 8 If i Mod 3 = 0 Then Print x(i \ 3, i Mod 3) = Format(s(i) * num, "0.00") Print num * s(i); Next End Sub
Dim num As Single, x(2, 2) As Double, s As Variant
s = Array(2, 7, 6, 9, 5, 1, 4, 3, 8)
Randomize
num = Format(Rnd * 100, "0.00")
For i = 0 To 8
If i Mod 3 = 0 Then Print
x(i \ 3, i Mod 3) = Format(s(i) * num, "0.00")
Print num * s(i);
Next
End Sub