经测试通过
Dim a As Integer, LessThan40 As Integer, Is40To70 As Integer, MoreThan70 As Integer
For i = 1 To 100
a = Int(Rnd() * 89) + 10
Select Case a
Case Is <= 40
LessThan40 = LessThan40 + 1
Case Is > 70
MoreThan70 = MoreThan70 + 1
Case Else
Is40To70 = Is40To70 + 1
End Select
Next
MsgBox "小于等于40的" & LessThan40 & "个" & vbCrLf & "大于40小于等于70的" & Is40To70 & "个" & vbCrLf & "大于70的" & MoreThan70 & "个"
本文如未解决您的问题请添加抖音号:51dongshi(抖音搜索懂视),直接咨询即可。