| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛

excel练习-俄罗斯方块23.4.28.zip (50.21 KB)

Private Sub Workbook_Open()
Sheet1.Clear
Application.OnKey "{up}", "sheet1.UP"
Application.OnKey "{down}", "sheet1.DOWN"
Application.OnKey "{right}", "sheet1.RIGHT"
Application.OnKey "{left}", "sheet1.LEFT"
Range("A1").Select
End Sub
Sub main()
Dim Yanse As Integer
Cells(4, 5).Resize(20, 10).Interior.ColorIndex = 2
Cells(2, 9) = 0
Speed = 500
100:
No = Int(Rnd * 7) + 1
Zt = Int(Rnd * 4) + 1
Yanse = Int(Rnd * 7) + 1
Select Case Yanse
Case Is = 1
Color = 33
Case Is = 2
Color = 44
Case Is = 3
Color = 10
Case Is = 4
Color = 46
Case Is = 5
Color = 41
Case Is = 6
Color = 43
Case Is = 7
Color = 26
End Select
X = 4
Select Case No
Case Is = 1
Y = Int(Rnd * 10) + 5
Case Is < 4
Y = Int(Rnd * 9) + 5
Case Is < 7
Y = Int(Rnd * 8) + 5
End Select
Tetris CInt(No), CInt(Zt), CInt(Color), CInt(X), CInt(Y)
Hx = Minh(CInt(No), CInt(Zt), CInt(X), CInt(Y))
Do While Hx > 0
Application.ScreenUpdating = False
Tetris CInt(No), CInt(Zt), 2, CInt(X), CInt(Y)
X = X + 1
Tetris CInt(No), CInt(Zt), CInt(Color), CInt(X), CInt(Y)
Hx = Minh(CInt(No), CInt(Zt), CInt(X), CInt(Y))
Application.ScreenUpdating = True
Sleep Speed
DoEvents
Loop
kill
For j = 5 To 14
If Cells(7, j).Interior.ColorIndex <> 2 Then
MsgBox "GAME OVER!!": Score = Cells(2, 9): tiaozhanbang
Exit Sub
End If
Next
GoTo 100
200:
End Sub

2016 也不好使

DO IT YOURSELF !

office2019运行键盘无反应，改用API获取键盘了

```Do While Hx > 0
Application.ScreenUpdating = False
Tetris (No), (Zt), 2, (x), (y)
x = x + 1
Tetris (No), (Zt), (Color), (x), (y)
Hx = Minh((No), (Zt), (x), (y))

If PeekMessage(msgMessage, lXLhwnd, WM_KEYDOWN, WM_KEYDOWN, PM_REMOVE) Then
iKeyCode = msgMessage.time
If iKeyCode = vbKeyUp Or iKeyCode = vbKeyW Then UP
If iKeyCode = vbKeyDown Or iKeyCode = vbKeyS Then DOWN
If iKeyCode = vbKeyLeft Or iKeyCode = vbKeyA Then LEFT
If iKeyCode = vbKeyRight Or iKeyCode = vbKeyD Then RIGHT
End If

Application.ScreenUpdating = True

DoEvents
Sleep Speed
Loop

```

excel练习-俄罗斯方块23.4.28.xls.7z (42.01 KB)

[此贴子已经被作者于2023-5-17 16:35编辑过]

，谢谢，按照指点使用了PeekMessage函数，excel2010也能响应按键了，就是运行时出现400错误

[此贴子已经被作者于2023-6-3 12:44编辑过]

• 5
• 1/1页
• 1