- 积分
- 1697
- 明经币
- 个
- 注册时间
- 2025-2-14
- 在线时间
- 小时
- 威望
-
- 金钱
- 个
- 贡献
-
- 激情
-
|

楼主 |
发表于 2025-4-12 15:59:11
|
显示全部楼层
这几天开始学习VBA,来一个有斗、点数概率计算。 - Sub tt1()
- Dim i As Integer, j As Integer, n As Integer, k As Integer, l As Integer
- Dim bin_1 As Boolean
- Dim ary_1(1 To 5) As Integer
-
- For n = 1 To 1000
- bin_1 = False
- For i = 1 To 10
- For j = 1 To 5
- ary_1(j) = Application.WorksheetFunction.RandBetween(0, 9)
- Next j
- k = ary_1(Cells(i, 5).Value) + ary_1(Cells(i, 6).Value) + ary_1(Cells(i, 7).Value)
- If k Mod 10 = 0 Then
- bin_1 = True
- l = ary_1(Cells(i, 8).Value) + ary_1(Cells(i, 9).Value)
- If l > 10 Then
- l = l - 10
- End If
- Exit For
- End If
- Next i
-
- If bin_1 Then
- Cells(2, 2).Value = Cells(2, 2).Value + 1
- Cells(l + 3, 2).Value = Cells(l + 3, 2).Value + 1
- Else
- Cells(1, 2).Value = Cells(1, 2).Value + 1
- End If
- Next n
- End Sub
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有账号?注册
x
|