Excel版俄罗斯方块

     废话少说。现在我把一年多前的在Excel环境下用vba实现的俄罗斯方块的代码提供给大家，算是对拓展office应用的一个总结。由于程序是在去年写的，现在看来思路都有点不记得了，而且语句都不太高效。但我又懒得修改了，毕竟这个是可以正确运行的。大家参考我另外两篇相关的文章，试着做吧。

还是新建一个宏，键入下面代码。

Public Declare Function SetTimer Lib user32 (ByVal hwnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerFunc As Long) As Long
Public Declare Function KillTimer Lib user32 (ByVal hwnd As Long, ByVal nIDEvent As Long) As Long   首先是API函数调用的声明。

 

Type pos_
    row As Long
    col As Long
End Type

Type obj
    pos As pos_
    stat As Long
    typ As Long
    color As Long
End Type  基本对象数据结构的定义

Public cur_obj As obj
Public prv_obj As obj
Public nex_obj As obj
Public objs_array(27, 3) As pos_

Dim startpos As pos_
Dim nextpos As pos_

Global score As Long 分数
Public score_level As Long
Dim level As Long

Public gaming As Boolean
Public pulse As Boolean

Public interval As Long   定时器时间间隙
Public timerset As Long   定时器

Public top As Long   记录方块堆积的最高层所在行

Public Const mosttop As Long = 5   游戏区域的顶，当方块堆积到这里游戏结束
Public Const left As Long = 5   游戏区域左边界
Public Const right As Long = 22   游戏区域左边界
Public Const middle As Long = (left + right) / 2   游戏区域中线，用以定位
Public Const bottom As Long = 25   游戏区域底

Sub main()
    gaming = False

    If Worksheets.Count < 2 Then
        ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count)
    Else
        Worksheets(Worksheets.Count).Select
    End If
    Load UserForm1
    UserForm1.Show
    End Sub

Function game_initial()
    游戏初始化函数
    startpos.row = mosttop
    startpos.col = middle
    nextpos.row = mosttop
    nextpos.col = right + 8
    top = bottom - 1
    score = 0
    Range(Cells(mosttop + 1, left), Cells(bottom - 1, left)).Interior.ColorIndex = 1
    Range(Cells(mosttop + 1, right), Cells(bottom - 1, right)).Interior.ColorIndex = 1
    Range(Cells(bottom, left), Cells(bottom, right)).Interior.ColorIndex = 1
    Range(Cells(bottom, left), Cells(bottom, right)) =
   
    If Not gaming Then
   
    Cells.ColumnWidth = 1
    Cells.RowHeight = 10
       初始化各形状的方块，我都忘了哪个对应哪种类型了
    objs_array(0, 0).row = -1
    objs_array(0, 0).col = -1
    objs_array(0, 1).row = 0
    objs_array(0, 1).col = -1
    objs_array(0, 2).row = 0
    objs_array(0, 2).col = 0
    objs_array(0, 3).row = 1
    objs_array(0, 3).col = 0
   
    objs_array(1, 0).row = 0
    objs_array(1, 0).col = 0
    objs_array(1, 1).row = 0
    objs_array(1, 1).col = 1
    objs_array(1, 2).row = 1
    objs_array(1, 2).col = 0
    objs_array(1, 3).row = 1
    objs_array(1, 3).col = -1
   
    objs_array(2, 0).row = -1
    objs_array(2, 0).col = -1
    objs_array(2, 1).row = 0
    objs_array(2, 1).col = -1
    objs_array(2, 2).row = 0
    objs_array(2, 2).col = 0
    objs_array(2, 3).row = 1
    objs_array(2, 3).col = 0
   
    objs_array(3, 0).row = 0
    objs_array(3, 0).col = 0
    objs_array(3, 1).row = 0
    objs_array(3, 1).col = 1
    objs_array(3, 2).row = 1
    objs_array(3, 2).col = 0
    objs_array(3, 3).row = 1
    objs_array(3, 3).col = -1
   
    type 2
    objs_array(4, 0).row = -1
    objs_array(4, 0).col = 0
    objs_array(4, 1).row = 0
    objs_array(4, 1).col = 0
    objs_array(4, 2).row = 0
    objs_array(4, 2).col = -1
    objs_array(4, 3).row = 1
    objs_array(4, 3).col = -1
   
    objs_array(5, 0).row = 0
    objs_array(5, 0).col = -1
    objs_array(5, 1).row = 0
    objs_array(5, 1).col = 0
    objs_array(5, 2).row = 1
    objs_array(5, 2).col = 0
    objs_array(5, 3).row = 1
    objs_array(5, 3).col = 1
   
    objs_array(6, 0).row = -1
    objs_array(6, 0).col = 0
    objs_array(6, 1).row = 0
    objs_array(6, 1).col = 0
    objs_array(6, 2).row = 0
    objs_array(6, 2).col = -1
    objs_array(6, 3).row = 1
    objs_array(6, 3).col = -1
   
    objs_array(7, 0).row = 0
    objs_array(7, 0).col = -1
    objs_array(7, 1).row = 0
    objs_array(7, 1).col = 0
    objs_array(7, 2).row = 1
    objs_array(7, 2).col = 0
    objs_array(7, 3).row = 1
    objs_array(7, 3).col = 1
   
    type 3
    objs_array(8, 0).row = -1
    objs_array(8, 0).col = 0
    objs_array(8, 1).row = 0
    objs_array(8, 1).col = 0
    objs_array(8, 2).row = 0
    objs_array(8, 2).col = 1
    objs_array(8, 3).row = 1
    objs_array(8, 3).col = 0
   
    objs_array(9, 0).row = -1
    objs_array(9, 0).col = 0
    objs_array(9, 1).row = 0
    objs_array(9, 1).col = 0
    objs_array(9, 2).row = 0
    objs_array(9, 2).col = -1
    objs_array(9, 3).row = 0
    objs_array(9, 3).col = 1
   
    objs_array(10, 0).row = -1
    objs_array(10, 0).col = 0
    objs_array(10, 1).row = 0
    objs_array(10, 1).col = 0
    objs_array(10, 2).row = 0
    objs_array(10, 2).col = -1
    objs_array(10, 3).row = 1
    objs_array(10, 3).col = 0
   
    objs_array(11, 0).row = 0
    objs_array(11, 0).col = -1
    objs_array(11, 1).row = 0
    objs_array(11, 1).col = 0
    objs_array(11, 2).row = 0
    objs_array(11, 2).col = 1
    objs_array(11, 3).row = 1
    objs_array(11, 3).col = 0
   
    type 4
    objs_array(12, 0).row = 0
    objs_array(12, 0).col = 0
    objs_array(12, 1).row = 1
    objs_array(12, 1).col = 0
    objs_array(12, 2).row = 2
    objs_array(12, 2).col = 0
    objs_array(12, 3).row = 3
    objs_array(12, 3).col = 0
   
    objs_array(13, 0).row = 0
    objs_array(13, 0).col = 0
    objs_array(13, 1).row = 0
    objs_array(13, 1).col = 1
    objs_array(13, 2).row = 0
    objs_array(13, 2).col = 2
    objs_array(13, 3).row = 0
    objs_array(13, 3).col = 3
   
    objs_array(14, 0).row = 0
    objs_array(14, 0).col = 0
    objs_array(14, 1).row = 1
    objs_array(14, 1).col = 0
    objs_array(14, 2).row = 2
    objs_array(14, 2).col = 0
    objs_array(14, 3).row = 3
    objs_array(14, 3).col = 0
   
    objs_array(15, 0).row = 0
    objs_array(15, 0).col = 0
    objs_array(15, 1).row = 0
    objs_array(15, 1).col = 1
    objs_array(15, 2).row = 0
    objs_array(15, 2).col = 2
    objs_array(15, 3).row = 0
    objs_array(15, 3).col = 3
   
    type 5
    objs_array(16, 0).row = 0
    objs_array(16, 0).col = 0
    objs_array(16, 1).row = 0
    objs_array(16, 1).col = 1
    objs_array(16, 2).row = 1
    objs_array(16, 2).col = 0
    objs_array(16, 3).row = 1
    objs_array(16, 3).col = 1
   
    objs_array(17, 0).row = 0
    objs_array(17, 0).col = 0
    objs_array(17, 1).row = 0
    objs_array(17, 1).col = 1
    objs_array(17, 2).row = 1
    objs_array(17, 2).col = 0
    objs_array(17, 3).row = 1
    objs_array(17, 3).col = 1
   
    objs_array(18, 0).row = 0
    objs_array(18, 0).col = 0
    objs_array(18, 1).row = 0
    objs_array(18, 1).col = 1
    objs_array(18, 2).row = 1
    objs_array(18, 2).col = 0
    objs_array(18, 3).row = 1
    objs_array(18, 3).col = 1
   
    objs_array(19, 0).row = 0
    objs_array(19, 0).col = 0
    objs_array(19, 1).row = 0
    objs_array(19, 1).col = 1
    objs_array(19, 2).row = 1
    objs_array(19, 2).col = 0
    objs_array(19, 3).row = 1
    objs_array(19, 3).col = 1
   
    type 6
    objs_array(20, 0).row = -2
    objs_array(20, 0).col = 0
    objs_array(20, 1).row = -1
    objs_array(20, 1).col = 0
    objs_array(20, 2).row = 0
    objs_array(20, 2).col = 0
    objs_array(20, 3).row = 0
    objs_array(20, 3).col = 1
   
    objs_array(21, 0).row = -1
    objs_array(21, 0).col = 0
    objs_array(21, 1).row = 0
    objs_array(21, 1).col = 0
    objs_array(21, 2).row = 0
    objs_array(21, 2).col = -1
    objs_array(21, 3).row = 0
    objs_array(21, 3).col = -2
   
    objs_array(22, 0).row = 0
    objs_array(22, 0).col = -1
    objs_array(22, 1).row = 0
    objs_array(22, 1).col = 0
    objs_array(22, 2).row = 1
    objs_array(22, 2).col = 0
    objs_array(22, 3).row = 2
    objs_array(22, 3).col = 0
   
    objs_array(23, 0).row = 0
    objs_array(23, 0).col = 0
    objs_array(23, 1).row = 0
    objs_array(23, 1).col = 1
    objs_array(23, 2).row = 0
    objs_array(23, 2).col = 2
    objs_array(23, 3).row = 1
    objs_array(23, 3).col = 0
   
    type 7
    objs_array(24, 0).row = -2
    objs_array(24, 0).col = 0
    objs_array(24, 1).row = -1
    objs_array(24, 1).col = 0
    objs_array(24, 2).row = 0
    objs_array(24, 2).col = 0
    objs_array(24, 3).row = 0
    objs_array(24, 3).col = -1
   
    objs_array(25, 0).row = 0
    objs_array(25, 0).col = -2
    objs_array(25, 1).row = 0
    objs_array(25, 1).col = -1
    objs_array(25, 2).row = 0
    objs_array(25, 2).col = 0
    objs_array(25, 3).row = 1
    objs_array(25, 3).col = 0
   
    objs_array(26, 0).row = 0
    objs_array(26, 0).col = 0
    objs_array(26, 1).row = 0
    objs_array(26, 1).col = 1
    objs_array(26, 2).row = 1
    objs_array(26, 2).col = 0
    objs_array(26, 3).row = 2
    objs_array(26, 3).col = 0
   
    objs_array(27, 0).row = -1
    objs_array(27, 0).col = 0
    objs_array(27, 1).row = 0
    objs_array(27, 1).col = 0
    objs_array(27, 2).row = 0
    objs_array(27, 2).col = 1
    objs_array(27, 3).row = 0
    objs_array(27, 3).col = 2
    End If

    Randomize
    nex_obj.typ = Int(7 * Rnd)
    nex_obj.stat = Int(4 * Rnd)
    nex_obj.color = Int(8 * Rnd) + 3
    nex_obj.pos = nextpos
    cur_obj = nex_obj
    prv_obj = cur_obj
    Call obj_draw
   
    Randomize
    cur_obj.typ = Int(7 * Rnd)
    cur_obj.stat = Int(4 * Rnd)
    cur_obj.color = Int(8 * Rnd) + 3
    cur_obj.pos = startpos
    prv_obj = cur_obj
    Call obj_draw
   
    level = 1000
    pulse = False
    interval = 800
    gaming = True
End Function

Public Function obj_left()   游戏对象向左移动，需判断是否超越左边界
    Dim i As Long
    Dim ii As Long
    Dim nextcol As Long
    Dim collide As Boolean
   
    collide = False
    nextcol = cur_obj.pos.col - 1
   
    ii = cur_obj.typ * 4 + cur_obj.stat
   
    For i = 0 To 3
        If ((nextcol + objs_array(ii, i).col <= left) Or Cells(cur_obj.pos.row + objs_array(ii, i).row, nextcol + objs_array(ii, i).col) = ) Then collide = True: Exit For
    Next i
    If (Not collide) Then
        prv_obj = cur_obj
        cur_obj.pos.col = nextcol
        Call obj_draw
    End If
End Function

Public Function obj_right()   游戏对象向右移动，需判断是否超越右边界
    Dim i As Long
    Dim ii As Long
    Dim nextcol As Long
    Dim collide As Boolean
   
    collide = False
    nextcol = cur_obj.pos.col + 1
   
    ii = cur_obj.typ * 4 + cur_obj.stat
   
    For i = 1 To 3
        If ((nextcol + objs_array(ii, i).col >= right) Or Cells(cur_obj.pos.row + objs_array(ii, i).row, nextcol + objs_array(ii, i).col) = ) Then collide = True: Exit For
    Next i
    If (Not collide) Then
        prv_obj = cur_obj
        cur_obj.pos.col = nextcol
        Call obj_draw
    End If
End Function

Public Function obj_change()   游戏对象下落形态的改变
    Dim i As Long
    Dim ii As Long
    Dim iii As Long
    Dim iiii As Long
    Dim nextstat As Long
    Dim nextcol As Long
    Dim collide As Boolean
   
    collide = False
    nextstat = cur_obj.stat + 1
    If (nextstat >= 4) Then
        nextstat = nextstat Mod 4
    End If
    ii = cur_obj.typ * 4 + nextstat
    nextcol = cur_obj.pos.col
   
    If cur_obj.pos.col <= left + 3 Then
        For i = 0 To 3
            iii = left + 1 - cur_obj.pos.col - objs_array(ii, i).col
            If (iii >= 0 And iii > iiii) Then iiii = iii
        Next i
        nextcol = nextcol + iiii
        For i = 0 To 3
            If Cells(cur_obj.pos.row + objs_array(ii, i).row, nextcol + objs_array(ii, i).col) = Then collide = True: Exit For
        Next i
    ElseIf cur_obj.pos.col >= right - 5 Then
        For i = 0 To 3
            iii = cur_obj.pos.col + objs_array(ii, i).col - right + 1
            If (iii >= 0 And iii > iiii) Then iiii = iii
        Next i
        nextcol = nextcol - iiii
        For i = 0 To 3
            If Cells(cur_obj.pos.row + objs_array(ii, i).row, nextcol + objs_array(ii, i).col) = Then collide = True: Exit For
        Next i
    Else
        For i = 0 To 3
            If Cells(cur_obj.pos.row + objs_array(ii, i).row, nextcol + objs_array(ii, i).col) = Then collide = True: Exit For
        Next i
    End If
   
    If Not collide Then
        prv_obj = cur_obj
        cur_obj.stat = nextstat
        cur_obj.pos.col = nextcol
        Call obj_draw
    End If
End Function

Function obj_fall()   游戏对象下落
    
    Dim i As Long
    Dim ii As Long
    Dim collide As Boolean
   
    Dim j As Long
    Dim k As Long
   
    Dim nextrow As Long
   
    collide = False
    ii = cur_obj.typ * 4 + cur_obj.stat
    nextrow = cur_obj.pos.row + 1

       判断是否下落到底
   For i = 0 To 3
        If (Cells(nextrow + objs_array(ii, i).row, cur_obj.pos.col + objs_array(ii, i).col) = Or nextrow + objs_array(ii, i).row >= bottom) Then collide = True: Exit For
    Next i
   
    If Not collide Then
        prv_obj = cur_obj
        cur_obj.pos.row = nextrow
        Call obj_draw
    Else
        score = score + 10
        score_level = 0
       
        ii = cur_obj.typ * 4 + cur_obj.stat
        For i = 0 To 3
            Cells(cur_obj.pos.row + objs_array(ii, i).row, cur_obj.pos.col + objs_array(ii, i).col) =
        Next i
       
        If cur_obj.pos.row + objs_array(ii, 0).row < top Then
            top = cur_obj.pos.row + objs_array(ii, 0).row
        End If
           这里我偷懒用了一个不具通用性的方法判断每个方块像素所在行是否已满，若满后则消去这行
        For i = 0 To 3
            For j = left + 1 To right - 1
                If Cells(cur_obj.pos.row + objs_array(ii, i).row, j) <> Then Exit For
            Next j
            If right - j <= 0 Then
                Cells(cur_obj.pos.row + objs_array(ii, i).row, left + 1) =  
                score_level = score_level + 1
            End If
        Next i

        If score_level > 0 Then
            Dim l As Long
                l = objs_array(ii, 3).row - objs_array(ii, 0).row
            Dim tmp_array(3) As Long
                For i = 0 To 3
                    tmp_array(i) = 0
                Next i
               消去满的几行后把由消去的这几行以上到顶的所有像素向下移动
            j = cur_obj.pos.row + objs_array(ii, 3).row
            k = 0
            For i = 0 To l
                If Cells(j - i, left + 1) =   Then
                    Range(Cells(j - i, left + 1), Cells(j - i, right - 1)).ClearContents
                    Range(Cells(j - i, left + 1), Cells(j - i, right - 1)).Interior.ColorIndex = 0
                Else
                    Range(Cells(j - i, left + 1), Cells(j - i, right - 1)).Cut Destination:=Range(Cells(j - k, left + 1), Cells(j - k, right - 1))
                    k = k + 1
                End If
            Next i
           
            l = cur_obj.pos.row + objs_array(ii, 0).row
            If top < l Then
                Range(Cells(top, left + 1), Cells(l - 1, right - 1)).Cut Destination:=Range(Cells(top + score_level, left + 1), Cells(l - 1 + score_level, right - 1))
            End If
            Range(Cells(top, left + 1), Cells(top + score_level - 1, right - 1)).ClearContents
            Range(Cells(top, left + 1), Cells(top + score_level - 1, right - 1)).Interior.ColorIndex = 0
           
            top = top + score_level
        End If
        score = score + 50 * score_level * (1 + score_level)
        UserForm1.Label2.Caption = Now you have the score of + Str(score)
        If score >= level Then
            level = level + 800
            interval = interval - 150
            If interval < 50 Then
                interval = 50
            End If
            If timerset <> 0 Then
            timerset = KillTimer(0, timerset)
            End If
            pulse = False
        End If
       
        判断方块是否堆积到顶，若未则生成下一方块，否则游戏结束
        If top > mosttop Then
            Call reinitial: Exit Function
        Else: Call game_over: Exit Function
        End If
    End If
End Function

Function obj_draw()
    Dim i As Long
    Dim ii As Long
   
    ii = prv_obj.typ * 4 + prv_obj.stat
    For i = 0 To 3
        Cells(prv_obj.pos.row + objs_array(ii, i).row, prv_obj.pos.col + objs_array(ii, i).col).Interior.ColorIndex = 0
    Next i
    ii = cur_obj.typ * 4 + cur_obj.stat
    For i = 0 To 3
        Cells(cur_obj.pos.row + objs_array(ii, i).row, cur_obj.pos.col + objs_array(ii, i).col).Interior.ColorIndex = cur_obj.color
    Next i
End Function

Function reinitial()
   
    If gaming Then
    prv_obj = nex_obj
    Randomize
    nex_obj.typ = Int(7 * Rnd)
    nex_obj.stat = Int(4 * Rnd)
    nex_obj.color = Int(8 * Rnd) + 3
    nex_obj.pos = nextpos
    cur_obj = nex_obj
    Call obj_draw
   
   cur_obj = prv_obj
    cur_obj.pos = startpos
    prv_obj = cur_obj
    Call obj_draw
    End If
End Function

Function game_over()
    If timerset <> 0 Then
        timerset = KillTimer(0, timerset)
    End If
    If MsgBox(Try it again?, vbOKCancel, Game over temporarily) = vbOK Then
        Cells.ClearContents
        Cells.Interior.ColorIndex = 0
        Call game_initial
    Else
        Cells.ClearContents
        Cells.Interior.ColorIndex = 0
        gaming = False
        SendKeys %{F4}
    End If
End Function

Public Sub pulse_()
    If gaming Then
        Call obj_fall
    End If
End Sub

以上是宏部分的代码，下面引入窗体后键入如下代码

Private Sub UserForm_Initialize()
    Label1.Caption = NO PLAY,NO GAME
    Call game_initial
   
    If (gaming) Then
        Label2.Caption = Move and change by ARROW keys.            Pause the game by P and end it by E
    Else
        Label2.Caption = Something happened. It needs to do something
        Call game_over
    End If
End Sub

Private Sub UserForm_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    If gaming Then
        If Not pulse Then
            pulse = True
            timerset = SetTimer(0, 0, interval, AddressOf pulse_)
            Label2.Caption = Move and change by ARROW keys.            Pause the game by P and end it by E
        End If
            Select Case KeyCode
                Case vbKeyLeft
                    Call obj_left
                Case vbKeyRight
                    Call obj_right
                Case vbKeyUp
                    Call obj_change
                Case vbKeyDown
                    Call obj_fall
                Case vbKeyP 销毁定时器，游戏暂停
                    If timerset <> 0 Then
                    timerset = KillTimer(0, timerset)
   pulse = False
                End If
                    Label2.Caption = Game Paused.You can resume by ANY key
                  
                Case vbKeyE
                    Call game_over
            End Select
    End If
   
End Sub

Private Sub UserForm_Terminate()
    MsgBox (You have complete the game with the score of + Str(score))
    Worksheets(1).Select
End Sub
有问题再发问吧，我都忘得七七八八了。