|
祝你能中500WO(∩_∩)O
本帖最后由 suye1010 于 2012-8-9 22:00 编辑
- Option Explicit
- Sub LuckyDraw()
- Dim Winning, d As Object, i As Integer, j As Integer, arrBet, arrDrawn, _
- BlueBall As Integer, RedBall As Integer, WinningRedBalls As Integer, TempTimes As Integer, TempPrize As Long
- Set d = CreateObject("Scripting.Dictionary")
- On Error Resume Next
- arrDrawn = Application.InputBox("请选择开奖信息区域", "开奖信息", , , , , , 8)
- arrBet = Application.InputBox("请选择投注号码区域", "投注信息", , , , , , 8)
- ReDim Winning(1 To 9, 0)
- For i = 1 To UBound(arrBet)
- d.RemoveAll
- For RedBall = 1 To 6
- d(arrBet(i, RedBall)) = arrBet(i, RedBall)
- Next RedBall
- For BlueBall = 1 To 16
- TempTimes = 0
- TempPrize = 0
- For j = 1 To UBound(arrDrawn)
- WinningRedBalls = 0
- For RedBall = 1 To 6
- If d.exists(arrDrawn(j, RedBall)) Then WinningRedBalls = WinningRedBalls + 1
- Next RedBall
- If arrDrawn(j, 7) = BlueBall Then
- TempTimes = TempTimes + 1
- Select Case WinningRedBalls
- Case Is < 3
- TempPrize = TempPrize + 5
- Case 3
- TempPrize = TempPrize + 10
- Case 4
- TempPrize = TempPrize + 200
- Case 5
- TempPrize = TempPrize + 3000
- Case 6
- TempPrize = TempPrize + 5000000
- End Select
- Else
- Select Case WinningRedBalls
- Case 4
- TempTimes = TempTimes + 1
- TempPrize = TempPrize + 10
- Case 5
- TempTimes = TempTimes + 1
- TempPrize = TempPrize + 200
- Case 6
- TempTimes = TempTimes + 1
- TempPrize = TempPrize + 100000
- End Select
- End If
- Next j
- If TempTimes > 1 Or TempPrize > 10 Then
- If Winning(1, 0) <> "" Then ReDim Preserve Winning(1 To 9, UBound(Winning, 2) + 1)
- For RedBall = 1 To 6
- Winning(RedBall, UBound(Winning, 2)) = arrBet(i, RedBall)
- Next RedBall
- Winning(7, UBound(Winning, 2)) = BlueBall
- Winning(8, UBound(Winning, 2)) = TempTimes
- Winning(9, UBound(Winning, 2)) = TempPrize
- End If
- Next BlueBall
- Next i
- Sheets(2).Range("A2:I5000").Clear
- Sheets(2).Cells(2, 1).Resize(UBound(Winning, 2), 9) = Application.Transpose(Winning)
- End Sub
复制代码 |
评分
-
查看全部评分
|