求助，最近学着编写了用vba俄罗斯方块，在wps2019表格里写的，方向键相应正常，在另一个电脑的excel2010下运行，方向键不响应，想请教一下，是vba在wps和excel里的差异造成的么，不知道从什么地方、怎么改起，大侠们帮着解惑，不胜感激。。。

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 也不好使

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

感谢两位大侠帮助，附件好像下不来

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

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

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