注册 登录
编程论坛 VB6论坛

新人求助,俄罗斯方块,vba写的,不会改了

as9876 发布于 2023-05-11 10:21, 1003 次点击
求助,最近学着编写了用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
4 回复
#2
wp2319572023-05-11 10:35
2016 也不好使
#3
apull2023-05-11 21:06
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




只有本站会员才能查看附件,请 登录

只有本站会员才能查看附件,请 登录
#4
as98762023-05-12 16:21
感谢两位大侠帮助,附件好像下不来

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

#5
as98762023-05-15 08:24
帖子我重新发到vba那边了
,谢谢,按照指点使用了PeekMessage函数,excel2010也能响应按键了,就是运行时出现400错误


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

1