ExcelVBA¥²¡¼¥à¥×¥í¥°¥é¥ß¥ó¥°¡©

½é¿´¼Ô¤Ç¤â¤­¤Ã¤È¤Ç¤­¤ë¡ª
£Å£ø£ã£å£ì¤µ¤¨»ý¤Ã¤Æ¤¤¤ì¤ÐÆÃÊ̤ʥ½¥Õ¥È¤ÏÉÔÍסª
¤¹¤°¤Ë¤Ç¤â»Ï¤á¤é¤ì¤ë´Êñ¥²¡¼¥à¥×¥í¥°¥é¥ß¥ó¥°¡ª
º£¤¹¤°»Ï¤á¤è¤¦¡ª

¥µ¥ó¥×¥ë¤ä¥²¡¼¥à¤Î¥À¥¦¥ó¥í¡¼¥É¤¬¤Ç¤­¤ëÊ̴ۤ⹥ɾ±¿±ÄÃæ¤Ç¤¹¡£
¤´°Õ¸«¤ä¤´¼ÁÌä¡¢¥²¡¼¥à¤Î´¶ÁÛÅù¤Ï·Ç¼¨ÈĤޤǤªµ¤·Ú¤Ë¡£À§Èó¡¢³§¤µ¤ó¤ÎÀ¼¤òʹ¤«¤»¤Æ¤¯¤À¤µ¤¤¡£±¿±Ä¡¢³«È¯¤ÎÎå¤ß¤Ë¤Ê¤ê¤Þ¤¹¡£



³Æ¼ï¥À¥¦¥ó¥í¡¼¥É¤Ï¥³¥Á¥é ¢­ °Õ¸«¡¦´¶ÁÛ¡¦¼ÁÌä¤Ï¥³¥Á¥é ¢­
±ÆÁÒ¸Ë Shadow warehouse ¥µ¥Ý¡¼¥È·Ç¼¨ÈÄ
¥Ö¥í¥°¤ÎÁ´ÂÎÁü¤Ï¥³¥Á¥é ¢­ ¥ê¥ó¥¯¤Î¥Ú¡¼¥¸¤Ï¥³¥Á¥é ¢­
¥µ¥¤¥È¥Þ¥Ã¥× ¼«Ê¬Ë̤ܰʥê¥ó¥¯


£Ã£è£á£ð£ô£å£ò.£µ£µ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£µ¡§»Äµ¡¿ôɽ¼¨­¢ ]

¢£¤Ä¤Å¤­¤Ç¤¹

¤µ¤Æ¡¢º£²ó¤ÏÁ°²ó¤Î³¤­¤Ç¤¹¡£
¹ÖºÂ¤òÄ̤·¤ÆºîÀ®¤·¤Æ¤¤¤ë¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤Ë¡¢»Äµ¡¿ô¤òɽ¼¨¤¹¤ë¤Ù¤¯½àÈ÷¤ò¤·¤¿Á°²ó¡£¤³¤³¤«¤é¤Ï¼ÂºÝ¤Î¥³¡¼¥É¤òµ­½Ò¤·¤Æ¤¤¤­¤Þ¤¹¡£

¤Þ¤º¤Ï¡¢¥³¡¼¥É¤ò¤¹¤ó¤Ê¤êÍý²ò¤¹¤ë¤¿¤á¤Ë¤â¡¢Á°²ó¤Î¹ÖºÂ¤ÇºÜ¤»¤¿¿·¤·¤¤¥×¥í¥·¡¼¥¸¥ã¤Î¹½Â¤¤ò¤â¤¦°ìÅÙ¸«¤Æ¤ß¤Þ¤·¤ç¤¦¡£

If À¸¤­¤Æ¤¤¤ë¤« = À¸¤­¤Æ¤¤¤ë Then
    If ±é½ÐÃæ¤«¤É¤¦¤« = ±é½ÐÃæ Then
        Éü³è»þ¤Î±é½Ð
    Else
        ¥­¡¼ÆþÎÏȽÄê½èÍý
        ¤Ï¤ß¤À¤·Ëɻ߽èÍý
        ¥·¥ç¥Ã¥È¤ò·â¤Ä¤«¤É¤¦¤«¤ÎȽÃÇ
    End If
Else
    »àË´»þ¤Î±é½Ð
End If
¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Î½èÍý

¿§¤ÎÃ夤¤Æ¤¤¤ëÉôʬ¤òº£²ó½¤Àµ¤·¤Þ¤¹¡£
½ÅÍפʤΤϡ¢¥­¥ã¥é¥¯¥¿¡¼¤ÎÀ¸»à¤Î¾õÂ֤䡢±é½ÐÃæ¤«¤É¤¦¤«¤Ë¤è¤Ã¤Æ¡¢½èÍý¤¬Ê¬´ô¤¹¤ë¤È¤¤¤¦»ÅÁȤߤǤ¹¡£

¾å¤Î¹½Â¤¿Þ¤ò¤è¤¯¸«¤Ê¤¬¤é¡¢¥²¡¼¥àÃæ¤Î¼ÂºÝ¤Îή¤ì¤ò¥¤¥á¡¼¥¸¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£

¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬¡¢º£¸½ºß¡¢À¸¤­¤Æ¤¤¤ë¤Î¤«¤¤¤Ê¤¤¤Î¤«¡¢¤½¤ì¤Ë¤è¤Ã¤ÆÀÖ¤¤»ú¤Ç½ñ¤«¤ì¤¿Ifʸ¤ÎÉôʬ¤Ç½èÍý¤¬Ê¬¤«¤ì¤Þ¤¹¡£
¤â¤·¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬À¸¤­¤Æ¤¤¤ë¤È¤¹¤ë¤È¡¢¡ØÉü³è»þ¤Î±é½Ð¡Ù¤«¡Ø¥×¥ì¥¤¥ä¡¼¤Î½èÍý¡Ù¤Î¤¤¤º¤ì¤«¤¬¼Â¹Ô¤µ¤ì¤Þ¤¹¡£µÕ¤Ë»à¤ó¤Ç¤¤¤ë¤È¤¹¤ë¤È¡¢¡Ø»àË´»þ¤Î±é½Ð¡Ù¤Ë½èÍý¤¬°Ü¤ê¤Þ¤¹¤Í¡£

¤¿¤À¤·¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬À¸¤­¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢¤µ¤é¤Ë¤â¤¦°ìÃʳ¬¤Îʬ´ô¤¬¤¢¤ê¤Þ¤¹¡£¤½¤ì¤¬ÀĤ¤»ú¤ÎIfʸ¤Çɽ¤µ¤ì¤Æ¤¤¤ëÉôʬ¤Ë¤¢¤¿¤ê¤Þ¤¹¡£
¤³¤³¤Ç¤Ï¡¢º£¸½ºß¡¢±é½Ð¤ò¤·¤Æ¤¤¤ëºÇÃæ¤«¤É¤¦¤«¤Ë¤è¤Ã¤Æ½èÍý¤¬Ê¬´ô¤·¤Þ¤¹¡£¤â¤·¤â±é½ÐÃæ¤Ç¤¢¤ì¤Ð¡¢¤½¤ì¤Ë±þ¤¸¤¿±é½Ð½èÍý¤¬¹Ô¤ï¤ì¤Þ¤¹¤·¡¢±é½ÐÃæ¤Ç¤Ê¤±¤ì¤Ð¡¢¤³¤ì¤ÏÄ̾ï¤Î¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤òÁàºî¤Ç¤­¤ë¾õÂ֤Ȥ¤¤¦¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£

¤¶¤Ã¤¯¤ê¤È¤·¤¿Î®¤ì¤Ï¡¢¤Ê¤ó¤È¤Ê¤¯Íý²ò¤Ç¤­¤Þ¤¹¤«¡©
¥­¥ã¥é¥¯¥¿¡¼¤¬À¸¤­¤Æ¤¤¤ë¤Î¤«¤É¤¦¤«¡¢¤½¤·¤Æ¡¢À¸¤­¤Æ¤¤¤¿¤È¤·¤¿¤é±é½ÐÃæ¤Ê¤Î¤«¤É¤¦¤«¡£¤Þ¤º¤Ï¤½¤ì¤ò¾ò·ïʬ´ô¤Ë¤è¤Ã¤ÆÈ½ÃǤ·¤Þ¤¹¡£¥«¡¼¥½¥ë¥­¡¼¤Ç¥­¥ã¥é¥¯¥¿¡¼¤òÁàºî¤Ç¤­¤ë¤È¤­¤Ï¡ØÀ¸¤­¤Æ¤¤¤Æ±é½Ð¤·¤Æ¤¤¤Ê¤¤¤È¤­¡Ù¤È¤¤¤¦¤³¤È¤Ç¤¹¤Í¡£¤³¤Î¹Í¤¨Êý¤ò¤è¤¯Íý²ò¤·¤¿¤¦¤¨¤Ç¡¢¼ÂºÝ¤Î¥³¡¼¥É¤ò¸«¤Æ¤ß¤Þ¤·¤ç¤¦¡£

Sub Player_Action()

    Dim S As Single
    Dim SS As Single
    
    Randomize

    
    With Player_Data
        If .Lif > 0 Then
            If .Par > 0 Then
                If .Y > 180 Then
                    .Y = .Y - 1
                Else
                    .Par = 0
                End If

            Else
                If GetAsyncKeyState(Left_Key) < 0 Then .X = .X - 3
                If GetAsyncKeyState(Up_Key) < 0 Then .Y = .Y - 3
                If GetAsyncKeyState(Right_Key) < 0 Then .X = .X + 3
                If GetAsyncKeyState(Down_Key) < 0 Then .Y = .Y + 3

                If .X - Player_Size < 0 Then .X = Player_Size
                If .X + Player_Size > 200 Then .X = 200 - Player_Size
                If .Y - Player_Size < 0 Then .Y = Player_Size
                If .Y + Player_Size > 200 Then .Y = 200 - Player_Size

                If Shot_Interval = 0 Then
                    If GetAsyncKeyState(Shot_Key) < 0 Then
                        Call P_Shot_Begin(.X, .Y, 1)
                        Shot_Interval = 1
                    End If
                Else
                    Shot_Interval = Shot_Interval + 1
                    If Shot_Interval > 7 Then Shot_Interval = 0
                End If
            End If
        Else
            .Par = .Par + 1
            If .Par > 50 Then
                .X = 100
                .Y = 210
                .Lif = 1
                .Par = 1
                Player_Stock = Player_Stock - 1
                Select Case Player_Stock
                    Case Is < 0
                        MsgBox "Game Over"
                    Case 0
                        UserForm1.Stock1.Visible = False
                    Case 1
                        UserForm1.Stock2.Visible = False
                End Select
            Else
                If .Par Mod 9 = 1 Then
                    S = Int(Rnd * 20) - 9
                    SS = Int(Rnd * 20) - 9
                    Call Burst_Begin(.X + S, .Y + SS)
                End If
            End If

        End If
        With UserForm1.Player
            .Left = Player_Data.X - Player_Size
            .Top = Player_Data.Y - Player_Size
        End With
    End With
    
End Sub

¤µ¤Æ¡¢¤Ê¤ó¤À¤«¥«¥é¥Õ¥ë¤Ê¥³¡¼¥É¤Ë¤Ê¤Ã¤Á¤ã¤¤¤Þ¤·¤¿¡£
¿§¤ÎÃ夤¤Æ¤¤¤ëÉôʬ¤¬º£²óÊѹ¹¤Ë¤Ê¤Ã¤¿Éôʬ¤Ç¤¹¡£Àè¤Û¤É¤Î¹½Â¤¿Þ¤È¡¢Æ±¤¸Í×ÎΤǿ§¤¬Ã夤¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢¤è¤¯¸«Èæ¤Ù¤Æ¤ß¤ë¤È¤Ê¤ó¤È¤Ê¤¯¹½Â¤¤¬¤ï¤«¤ë¤È»×¤¤¤Þ¤¹¡£

¤Þ¤º¤ÏÎ理Îʸ»úÉôʬ¡£¤³¤³¤Ïñ½ã¤ËÄɲ䵤줿Éôʬ¤Ç¤¹¡£¥³¡¼¥É¤òÄɲ乤ë¤Ë¤¢¤¿¤ê¡¢¿·¤¿¤ËɬÍפȤʤëÊÑ¿ô¤ÎÀë¸À¤ò¤·¤Æ¤¤¤Þ¤¹¡£¤µ¤é¤Ë¡¢Íð¿ô¤ò»ÈÍѤ¹¤ë¤Î¤ÇRandomize¤ò»È¤Ã¤Æ¡¢Íð¿ô¥¸¥§¥Í¥ì¡¼¥¿¤ò½é´ü²½¤·¤Æ¤¤¤Þ¤¹¡£
Randomize¤Ë¤Ä¤¤¤Æ¤Ï¡¢°ÊÁ°¤Î¹ÖºÂ¤Ç¾Ü¤·¤¯²òÀ⤷¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢¤ï¤«¤é¤Ê¤¤¿Í¤Ï¤½¤Á¤é¤âÊ»¤»¤Æ¤É¤¦¤¾(Chapter12¤ò»²¾È)¡£

¤µ¤Æ¡¢¤½¤Î¼¡¤ÏÀÖ¤¤»ú¤ÎIfʸ¤Ç¡¢¥­¥ã¥é¥¯¥¿¡¼¤¬À¸¤­¤Æ¤¤¤ë¤«»à¤ó¤Ç¤¤¤ë¤«¤ò¥Á¥§¥Ã¥¯¤·¤Æ½èÍý¤òʬ´ô¤·¤Þ¤¹¡£
Í×ÁÇLif¤¬¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤ÎÀ¸Â¸¾õÂÖ¤òɽ¤·¤Æ¤ª¤ê¡¢¤³¤ÎÉôʬ¤¬£°¤è¤êÂ礭¤±¤ì¤Ð¡¢¥­¥ã¥é¥¯¥¿¡¼¤ÏÀ¸¤­¤Æ¤¤¤Þ¤¹¡£µÕ¤Ë£°°Ê²¼¤À¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢¥­¥ã¥é¥¯¥¿¡¼¤Ï»à¤ó¤Ç¤¤¤ë¤È¤¤¤¦¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¤Í¡£

¤½¤·¤ÆÀĤ¤»ú¤Ç½ñ¤«¤ì¤Æ¤¤¤ëIfʸ¤Ç¤Ï¡¢±é½Ð¤ò¹Ô¤Ã¤Æ¤¤¤ëºÇÃæ¤«¤É¤¦¤«¤òȽÄꤷ¤Þ¤¹¡£±é½Ð¤ò¹Ô¤Ã¤Æ¤¤¤ë¤«¤É¤¦¤«¤Ï¡¢Í×ÁÇPar¤¬´ÉÍý¤·¤Þ¤¹¡£¤³¤ÎÍ×ÁǤÎÃͤ¬£°°Ê³°¤Î»þ¤Ë¤Ï¡¢²¿¤«¤·¤é¤Î±é½Ð¤ò¹Ô¤Ã¤Æ¤¤¤ëºÇÃæ¤È¤·¤Æ¹Í¤¨¤Þ¤¹¡£

¾å¤Î¤Û¤¦¤Ç½Ð¤Æ¤¯¤ë²«¿§¤¤»ú¤Î½èÍý¤Ç¤Ï¡¢¡ØÉü³è»þ¤Î±é½Ð¡Ù¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¡£¤³¤³¤Ç¤Ï¡¢¥­¥ã¥é¥¯¥¿¡¼¤¬²èÌ̤β¼¤Î¤Û¤¦¤«¤é¡¢¤æ¤Ã¤¯¤ê¤ÈÅо줹¤ë¤è¤¦¤Ë½èÍý¤·¤Æ¤¤¤Þ¤¹¡£
¥­¥ã¥é¥¯¥¿¡¼¤Î½Ä°ÌÃÖ¤¬¡¢°ìÄê¤ÎºÂɸ¤Ë㤹¤ë¤Þ¤Ç¡¢¤¹¤³¤·¤º¤Ä¥­¥ã¥é¥¯¥¿¡¼¤ò°Üư¤·¤Æ¤¤¤ë¤ï¤±¤Ç¤¹¡£»ØÄꤵ¤ì¤¿ºÂɸ¤Þ¤ÇÅþ㤷¤¿¤é¡¢±é½Ð¤ò½ª¤ï¤é¤»¤ë¤¿¤á¤ËÍ×ÁÇPar¤Ë£°¤òÂåÆþ¤·¤Þ¤¹¡£¤³¤³¤Ç£°¤òÂåÆþ¤·¤¿¤³¤È¤Ë¤è¤Ã¤Æ¡¢¼¡²ó¤Î¥ë¡¼¥×¤«¤é¤Ï¥­¥ã¥é¥¯¥¿¡¼¤òÄ̾ïÄ̤ꥫ¡¼¥½¥ë¥­¡¼¤ÇÁàºî¤Ç¤­¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

¤³¤³¤Þ¤Ç¤¬¡¢¥­¥ã¥é¥¯¥¿¡¼¤¬À¸¤­¤Æ¤¤¤ë¾ì¹ç¤Î½èÍý¤Ë¤Ê¤ê¤Þ¤¹¡£
¥­¥ã¥é¥¯¥¿¡¼¤¬À¸¤­¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢Éü³è»þ¤Î±é½Ð¤«¡¢¤¢¤ë¤¤¤Ï¥«¡¼¥½¥ë¥­¡¼¤ÇÁàºî¤Ç¤­¤ë¾õÂÖ¤«¤Î¤¤¤º¤ì¤«¤¬¼Â¹Ô¤µ¤ì¤ë¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¤Í¡£


¢£¤½¤ì¤¸¤ã»àË´»þ¤Î½èÍý¤Ï¡©

¤µ¤Æ¼¡¤Ï¥­¥ã¥é¥¯¥¿¡¼¤¬»à¤ó¤Ç¤¤¤ë¾ì¹ç¤Î½èÍý¤Ç¤¹¡£
²¼¤Î¤Û¤¦¤Ë¤¢¤ë²«¿§¤¤»ú¤ÎÉôʬ¤¬¤³¤ì¤Ë¤¢¤¿¤ê¤Þ¤¹¡£

¤³¤³¤Ï¾¯¤·Ê£»¨¤Ê¤Î¤Ç¡¢È´¿è¤·¤¿¥³¡¼¥É¤òºÜ¤»¤Þ¤¹¡£

.Par = .Par + 1 '­¡
If .Par > 50 Then '­¢
    .X = 100
    .Y = 210
    .Lif = 1
    .Par = 1
    Player_Stock = Player_Stock - 1
    Select Case Player_Stock
        Case Is < 0
            MsgBox "Game Over" '­£
        Case 0
            UserForm1.Stock1.Visible = False '­£
        Case 1
            UserForm1.Stock2.Visible = False '­£
    End Select
Else
    If .Par Mod 9 = 1 Then '­¤
        S = Int(Rnd * 20) - 9
        SS = Int(Rnd * 20) - 9
        Call Burst_Begin(.X + S, .Y + SS)
    End If
End If

¤Þ¤º­¡¤ÎÉôʬ¤Ç¤¹¡£
¤³¤³¤Ç¤ÏÍ×ÁÇPar¤ÎÃͤò¥×¥é¥¹£±¤·¤Æ¤¤¤Þ¤¹¤Í¡£¤³¤ì¤Ï²¿¤Î¤¿¤á¤«¤È¤¤¤¤¤Þ¤¹¤È¡¢Í×ÁÇPar¤ò¥«¥¦¥ó¥¿¤ÎÌò³ä¤È¤·¤Æ»È¤¦¤¿¤á¤Ç¤¹¡£
¥ë¡¼¥×¤¹¤ë¤¿¤Ó¤Ë¥×¥é¥¹£±¤º¤ÄÁý¤ä¤·¤Æ¤¤¤ë¤ï¤±¤Ç¤¹¤«¤é¡¢±é½Ð¤¬»Ï¤Þ¤Ã¤Æ¤«¤é¡¢¤É¤Î¤¯¤é¤¤¤Î»þ´Ö¤¬·Ð¤Ã¤Æ¤¤¤ë¤Î¤«¤Ï¡¢Í×ÁÇPar¤ÎÃͤòÄ´¤Ù¤ë¤³¤È¤Ç¤ï¤«¤ê¤Þ¤¹¡£¤¿¤¯¤µ¤ó¥«¥¦¥ó¥È¤µ¤ì¤¿¤¢¤È¤Ç¤¢¤ì¤Ð¡¢Â礭¤ÊÃͤ¬Æþ¤Ã¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¤·¡¢µÕ¤Ë¤Þ¤À¤¢¤Þ¤ê»þ´Ö¤¬·Ð¤Ã¤Æ¤¤¤Ê¤±¤ì¤Ð¡¢¾®¤µ¤ÊÃͤ¬Æþ¤Ã¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¡£

¤½¤ì¤òƧ¤Þ¤¨¤Æ­¢¤ÎÉôʬ¤ò¸«¤Æ¤¯¤À¤µ¤¤¡£
¤³¤³¤Ç¤Ï¡¢Í×ÁÇPar¤¬£µ£°¤è¤ê¤âÂ礭¤ÊÃͤˤʤäƤ¤¤ë¤«¤É¤¦¤«¥Á¥§¥Ã¥¯¤·¤Æ¤¤¤Þ¤¹¤Í¡£¤â¤·¤â£µ£°¤è¤ê¤âÂ礭¤Ê¿ôÃͤˤʤë¤Þ¤Ç»þ´Ö¤¬·Ð¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢¤³¤³¤Ç»àË´»þ¤Î±é½Ð¤ò½ª¤ï¤ê¤Ë¤·¤Æ¡¢Éü³è»þ¤Î½èÍý¤Ø°Ü¹Ô¤µ¤»¤Þ¤¹¡£
¥­¥ã¥é¥¯¥¿¡¼¤Î²£°ÌÃÖ¤ä½Ä°ÌÃÖ¤òÀßÄꤷ¤Æ¡¢¤µ¤é¤ËÀ¸¤­¤Æ¤¤¤ë¾õÂÖ¤ËÌ᤹¤¿¤á¡¢Í×ÁÇLif¤Ë£±¤òÂåÆþ¤·¤Æ¤¤¤Þ¤¹¡£¤Þ¤¿¡¢Éü³è»þ¤Î±é½Ð¤ò¹Ô¤ï¤»¤ë¤¿¤á¤Ë¡¢Í×ÁÇPar¤Ë¤â£±¤òÂåÆþ¤·¤Æ¤¤¤Þ¤¹¡£

¤½¤·¤Æ¡¢»Äµ¡¿ô¤òɽ¤¹ÊÑ¿ôPlayer_Stock¤ò¤Ò¤È¤Ä¸º¤é¤·¤Þ¤¹¡£¤³¤ì¤Ç»Äµ¡¿ô¤¬¤Ò¤È¤Ä¾¯¤Ê¤¯¤Ê¤ë¤ï¤±¤Ç¤¹¤Í¡£

¤½¤Î¸å¡¢ÊÑ¿ôPlayer_Stock¤ÎÃͤ˱þ¤¸¤ÆSelect Caseʸ¤Ç½èÍý¤òʬ´ô¤·¤Æ¤¤¤Þ¤¹¡£¤³¤ì¤¬­£¤Ç¤¹¡£
ÊÑ¿ôPlayer_Stock¤ÎÃͤϵ¬ÄêÃͤǣ²¤¬Æþ¤Ã¤Æ¤¤¤Þ¤¹¡£
ÊÑ¿ôPlayer_Stock¤ÎÃͤ¬¡¢£±¤À¤Ã¤¿¤È¤­¤Ï£±²ó»à¤ó¤Ç¤·¤Þ¤Ã¤¿¤³¤È¤Ë¤Ê¤ê¡¢£°¤À¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢¤¹¤Ç¤Ë£²²ó»à¤ó¤Ç¤¤¤ë¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£¤â¤·¤â¤³¤³¤¬¥Þ¥¤¥Ê¥¹¤À¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢£³²ó»à¤ó¤À¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¤«¤é¡¢¥á¥Ã¥»¡¼¥¸¤òɽ¼¨¤·¤Æ¡¢¥²¡¼¥à¥ª¡¼¥Ð¡¼¤Î¾õÂ֤ˤʤ俤³¤È¤òÄÌÃΤ·¤Æ¤¤¤Þ¤¹¡£

¥²¡¼¥à¥ª¡¼¥Ð¡¼¤Ë¤Ê¤é¤Ê¤¤¾ì¹ç¤Ë¤Ï¡¢»Äµ¡¿ô¤òɽ¤¹¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¡Ø Stock1¡¦Stock2 ¡Ù¤òŬµ¹Èóɽ¼¨¤Ë¤·¤Æ¤¤¤Þ¤¹¡£

³¤¤¤Æ­¤¤ÎÉôʬ¡£Â¿Ê¬¥³¡¼¥É¤ò¸«¤¿¤À¤±¤Ç¡¢¤³¤ì¤¬²¿¤ò¤·¤Æ¤¤¤ë¥³¡¼¥É¤Ê¤Î¤«¤ï¤«¤ë¿Í¤Ï¾¯¤Ê¤¤¤È»×¤¤¤Þ¤¹¡£¼ÂºÝ¤Ë¤Ï¤³¤ó¤Ê¤³¤È¤·¤Ê¤¯¤Æ¤â¤¤¤¤¤ó¤Ç¤¹¤¬¡¢¡Ø±é½Ð¡Ù¤È¤¤¤¦°ÕÌ£¤Ç¤Ï·ë¹½½ÅÍפÊÉôʬ¤À¤È¸Ä¿ÍŪ¤Ë¤Ï»×¤¤¤Þ¤¹¡£

¼Â¤Ï¤³¤Î­¤¤ÎÉôʬ¤Ï¡¢ÈïÃÆ¤·¤¿¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬Çúȯ¤·¤Æ¤¤¤ë¥·¡¼¥ó¤ò±é½Ð¤·¤Æ¤¤¤Þ¤¹¡£
Ũ¥­¥ã¥é¥¯¥¿¡¼¤Ê¤é¤Þ¤À¤·¤â¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬ÈïÃÆ¤·¤Æ¤·¤Þ¤Ã¤¿¤È¤­¤Ë¡¢Ã±È¯¤ÎÇúȯ¤Ç½ª¤ï¤Ã¤Æ¤·¤Þ¤¦¤Î¤Ï¤Ê¤ó¤À¤«¼ä¤·¤¤µ¤¤¬¤·¤Þ¤¹¡£¤³¤ì¤Ï¤«¤Ê¤ê¸Ä¿ÍŪ¤Ê°Õ¸«¤Ç¤¹¤¬¡£

¤½¤³¤Ç¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î»àË´»þ¤Î±é½Ð¤È¤·¤Æ¡¢Éü³è¤¹¤ë¤Þ¤Ç¤Î´Ö£¹¥ë¡¼¥×¤´¤È¤ËÇúȯ¤Î¥¨¥Õ¥§¥¯¥È¤òÊ£¿ô²óɽ¼¨¤¹¤ë¤è¤¦¤Ë¤·¤Æ¤¤¤Þ¤¹¡£Mod±é»»»Ò¤ò»È¤Ã¤Æ¡¢Í×ÁÇPar¤ÎÃͤ¬£µ£°¤è¤ê¤âÂ礭¤¯¤Ê¤ë¤Þ¤Ç¤Î´Ö¡¢²¿ÅÙ¤«Çúȯ¤Î¥¨¥Õ¥§¥¯¥È¤¬È¯À¸¤¹¤ë¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
Çúȯ¥¨¥Õ¥§¥¯¥È¤ÎȯÀ¸¤¹¤ëºÂɸ¤â¥é¥ó¥À¥à¤Ë·è¤á¤Æ¤¤¤ë¤Î¤Ç¡¢¥­¥ã¥é¥¯¥¿¡¼¤¬Êø¤ìÍî¤Á¤ë¤è¤¦¤Ë²¿ÅÙ¤âÇúȯ¤·¤Æ¤¤¤ë¤è¤¦¤Ê´¶¤¸¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤È»×¤¤¤Þ¤¹¡£
¿ʬ¤³¤ì¤Ï¼ÂºÝ¤Ëư¤¯¤Î¤ò¸«¤Æ¤â¤é¤Ã¤¿¤Û¤¦¤¬¤ï¤«¤ê¤ä¤¹¤¤¤Î¤Ç¤Ï¤Ê¤¤¤«¤Ê¡£¸ÀÍÕ¤ÇÀâÌÀ¤¹¤ë¤Î¤¬Æñ¤·¤¤¡Ä¡Ä¡£¹ÖºÂ¤ÎºÇ¸å¤Ë¡¢¥µ¥ó¥×¥ë¤Ø¤Î¥ê¥ó¥¯¤¬¤¢¤ê¤Þ¤¹¤Î¤Ç¡¢¤è¤«¤Ã¤¿¤é¤½¤Á¤é¤«¤é¥µ¥ó¥×¥ë¤òÍî¤È¤·¤Æ¡¢¼ÂºÝ¤Ë¸«¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£¤½¤Î¤Û¤¦¤¬¤ï¤«¤ê¤ä¤¹¤¤¤È»×¤¤¤Þ¤¹¡£

¤È¤ê¤¢¤¨¤º¡¢¤³¤³¤Þ¤Ç¤ÎÁ´¥³¡¼¥É¤ò·ÇºÜ¤·¤Þ¤¹¤Î¤Ç¡¢¤ä¤ëµ¤¤Î¤¢¤ëÊý¤Ï¼«ÎϤǽ¤Àµ¤·¤Æ¤ß¤ë¤È¤¤¤¤¤Ç¤·¤ç¤¦¡£

'ɸ½à¥â¥¸¥å¡¼¥ëÀèÆ¬Éôʬ

'¢¡API¡¡Àë¸À

Declare Function GetTickCount Lib "kernel32" () As Long
Declare Function GetAsyncKeyState Lib "user32" (ByVal vKey As Long) As Integer
Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMillsecounds As Long)

'¢£¥­¥ã¥é¥¯¥¿¡¼¡¡¹½Â¤ÂÎÀë¸À
Type Chara
    X As Single
    Y As Single
    W As Single
    H As Single
    Lif As Long
    Typ As Long
    Par As Long
End Type

'¢£¥·¥ç¥Ã¥È¡¡¹½Â¤ÂÎÀë¸À
Type Shot
    X As Single
    Y As Single
    Vis As Boolean
    Typ As Long
End Type

'¢£ÈÆÍÑ¥ª¥Ö¥¸¥§¥¯¥È¡¡¹½Â¤ÂÎÀë¸À
Type Obj
    X As Single
    Y As Single
    W As Single
    H As Single
    Par As Long
End Type

'¡ü¥­¥ã¥é¥¯¥¿¡¼¡¡ÊÑ¿ôÀë¸À
Public Player_Data As Chara
Public Enemy_Data(9) As Chara

'¡ü¥·¥ç¥Ã¥È¡¡ÊÑ¿ôÀë¸À
Public P_Shot_Data(4) As Shot
Public E_Shot_Data(9) As Shot

'¡üÈÆÍÑ¥ª¥Ö¥¸¥§¥¯¥È¡¡ÊÑ¿ôÀë¸À
Public Burst_Data(2) As Obj

'¡ý¤½¤Î¾¡¡ÊÑ¿ôÀë¸À
Public Shot_Interval As Long
Public Total_Count As Long '¥²¡¼¥àÃæ¤Î¥«¥¦¥ó¥¿
Public Player_Stock As Long '¥×¥ì¥¤¥ä¡¼¤Î»Äµ¡¿ô

'¢¥Äê¿ôÀë¸À
Public Const Left_Key As Long = 37 '¥«¡¼¥½¥ëº¸
Public Const Up_Key As Long = 38 '¥«¡¼¥½¥ë¾å
Public Const Right_Key As Long = 39 '¥«¡¼¥½¥ë±¦
Public Const Down_Key As Long = 40 '¥«¡¼¥½¥ë²¼
Public Const Esc_Key As Long = 27 '£Å£ó£ã¥­¡¼
Public Const Shot_Key As Long = 90 '£Ú¥­¡¼
Public Const Player_Size As Single = 9
'¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î¼ÂºÝ¤ÎÂ礭¤µ
Public Const Shot_Size As Single = 3
'ÃÆ³Æ¼ï¤Î¼ÂºÝ¤ÎÂ礭¤µ
Public Const Enemy_Size As Single = 9
'Ũ¥­¥ã¥é¥¯¥¿¡¼¤Î¼ÂºÝ¤ÎÂ礭¤µ
Public Const Burst_Size As Single = 15
'Çúȯ¥¨¥Õ¥§¥¯¥È¤Î¼ÂºÝ¤ÎÂ礭¤µ


'½é´ü²½¤òôÅö¤¹¤ë¥×¥í¥·¡¼¥¸¥ã

Sub Init()
    With Player_Data
        .X = 100
        .Y = 210
        .W = 3
        .H = 3
        .Lif = 1
        .Typ = 0
        .Par = 1
    End With
    Erase P_Shot_Data
    Erase E_Shot_Data
    Erase Enemy_Data
    Erase Burst_Data
    Shot_Interval = 0
    Total_Count = 0
    Player_Stock = 2
    With UserForm1.Player
        .Visible = True
        .Top = 200
    End With

End Sub

'¥á¥¤¥ó¥×¥í¥»¥¹¤òôÅö¤¹¤ë¥×¥í¥·¡¼¥¸¥ã

Sub Main()

    Dim Flg As Boolean
    Dim Stm As Long
    
    Call Init
    
    Flg = False
    
    Do Until Flg
        Stm = GetTickCount
        Total_Count = Total_Count + 1
        Call Stage_Count
        Call Player_Action
        Call P_Shot_Action
        Call Enemy_Action
        Call E_Shot_Action
        Call Burst_Action
        DoEvents
        Do
            Call Sleep(1)
        Loop Until GetTickCount - Stm > 30
        If GetAsyncKeyState(Esc_Key) < 0 Then Flg = True
    Loop
    
End Sub


'Ũ¥­¥ã¥é¥¯¥¿¡¼¤Î½Ð¸½´ÉÍý¥×¥í¥·¡¼¥¸¥ã

Sub Stage_Count()
    Randomize
    Select Case Total_Count Mod 200
        Case 0
            Call Enemy_Begin(Int(Rnd * 120) + 40, -10, 1)
        Case 50
            Call Enemy_Begin(Int(Rnd * 120) + 40, -10, 2)
        Case 100
            Call Enemy_Begin(Int(Rnd * 120) + 40, -10, 3)
    End Select
End Sub


'¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤òôÅö¤¹¤ë¥×¥í¥·¡¼¥¸¥ã

Sub Player_Action()

    Dim S As Single
    Dim SS As Single
    
    Randomize
    
    With Player_Data
        If .Lif > 0 Then
            If .Par > 0 Then
                If .Y > 180 Then
                    .Y = .Y - 1
                Else
                    .Par = 0
                End If
            Else
                If GetAsyncKeyState(Left_Key) < 0 Then .X = .X - 3
                If GetAsyncKeyState(Up_Key) < 0 Then .Y = .Y - 3
                If GetAsyncKeyState(Right_Key) < 0 Then .X = .X + 3
                If GetAsyncKeyState(Down_Key) < 0 Then .Y = .Y + 3

                If .X - Player_Size < 0 Then .X = Player_Size
                If .X + Player_Size > 200 Then .X = 200 - Player_Size
                If .Y - Player_Size < 0 Then .Y = Player_Size
                If .Y + Player_Size > 200 Then .Y = 200 - Player_Size

                If Shot_Interval = 0 Then
                    If GetAsyncKeyState(Shot_Key) < 0 Then
                        Call P_Shot_Begin(.X, .Y, 1)
                        Shot_Interval = 1
                    End If
                Else
                    Shot_Interval = Shot_Interval + 1
                    If Shot_Interval > 7 Then Shot_Interval = 0
                End If
            End If
        Else
            .Par = .Par + 1
            If .Par > 50 Then
                .X = 100
                .Y = 210
                .Lif = 1
                .Par = 1
                Player_Stock = Player_Stock - 1
                Select Case Player_Stock
                    Case Is < 0
                        MsgBox "Game Over"
                    Case 0
                        UserForm1.Stock1.Visible = False
                    Case 1
                        UserForm1.Stock2.Visible = False
                End Select
            Else
                If .Par Mod 9 = 1 Then
                    S = Int(Rnd * 20) - 9
                    SS = Int(Rnd * 20) - 9
                    Call Burst_Begin(.X + S, .Y + SS)
                End If
            End If
        End If
        With UserForm1.Player
            .Left = Player_Data.X - Player_Size
            .Top = Player_Data.Y - Player_Size
        End With
    End With
    
End Sub



'¥·¥ç¥Ã¥ÈÀ¸À®¥×¥í¥·¡¼¥¸¥ã

Sub P_Shot_Begin(X As Single, Y As Single, Typ As Long)

    Dim L As Long

    For L = 0 To 4
        With P_Shot_Data(L)
            If Not .Vis Then
                .X = X
                .Y = Y
                .Typ = Typ
                .Vis = True
                UserForm1.Controls("P_Shot" & L + 1).Visible = True
                Exit For
            End If
        End With
    Next

End Sub


'¥·¥ç¥Ã¥È°Üư´ÉÍý¥×¥í¥·¡¼¥¸¥ã

Sub P_Shot_Action()

    Dim L As Long
    Dim LL As Long

    For L = 0 To 4
        With P_Shot_Data(L)
            If .Vis Then
                .Y = .Y - 6
                If .Y < -5 Then .Vis = False
                For LL = 0 To 9
                    If Enemy_Data(LL).Lif > 0 Then
                        If .X - 2 < Enemy_Data(LL).X + Enemy_Data(LL).W Then
                            If .X + 2 > Enemy_Data(LL).X - Enemy_Data(LL).W Then
                                If .Y - 2 < Enemy_Data(LL).Y + Enemy_Data(LL).H Then
                                    If .Y + 2 > Enemy_Data(LL).Y - Enemy_Data(LL).H Then
                                        .Vis = False
                                        With Enemy_Data(LL)
                                            Call Burst_Begin(.X, .Y)
                                            .Lif = 0
                                        End With
                                        Exit For
                                    End If
                                End If
                            End If
                        End If
                    End If
                Next
                With UserForm1.Controls("P_Shot" & L + 1)
                    If P_Shot_Data(L).Vis Then
                        .Left = P_Shot_Data(L).X - Shot_Size
                        .Top = P_Shot_Data(L).Y - Shot_Size
                    Else
                        .Visible = False
                    End If
                End With
            End If
        End With
    Next

End Sub


'Ũ¥­¥ã¥é¥¯¥¿¡¼À¸À®¥×¥í¥·¡¼¥¸¥ã

Sub Enemy_Begin(X As Single, Y As Single, Typ As Long)

    Dim L As Long
    
    For L = 0 To 9
        With Enemy_Data(L)
            If .Lif = 0 Then
                .X = X
                .Y = Y
                .W = 5
                .H = 5
                .Typ = Typ
                .Lif = 1
                .Par = 0
                With UserForm1.Controls("Enemy" & L + 1)
                    .Visible = True
                    Select Case Typ
                        Case 1
                            .Picture = UserForm1.Enemy_s1.Picture
                        Case 2, 3
                            .Picture = UserForm1.Enemy_s2.Picture
                    End Select
                End With
                Exit For
            End If
        End With
    Next
    
End Sub


'Ũ¥­¥ã¥é¥¯¥¿¡¼¤òôÅö¤¹¤ë¥×¥í¥·¡¼¥¸¥ã

Sub Enemy_Action()

    Dim L As Long
    Dim TCMOD
    
    TCMOD = Total_Count Mod 30
    
    For L = 0 To 9
        With Enemy_Data(L)
            If .Lif > 0 Then
                Select Case .Typ
                    Case 1
                        .Y = .Y + 1.5
                    Case 2
                        .X = .X + 0.5
                        .Y = .Y + 1
                    Case 3
                        .X = .X - 0.5
                        .Y = .Y + 1
                End Select
                If .X > 220 Then .Lif = 0
                If .Y > 220 Then .Lif = 0
                If .X < -20 Then .Lif = 0
                If .Y < -20 Then .Lif = 0
                If TCMOD = 0 Then
                    Select Case .Typ
                        Case 2
                            .Typ = 3
                        Case 3
                            .Typ = 2
                    End Select
                    Call E_Shot_Begin(.X, .Y + 2, .Typ)
                End If
            End If
        End With
        With UserForm1.Controls("Enemy" & L + 1)
            If Enemy_Data(L).Lif > 0 Then
                .Left = Enemy_Data(L).X - Enemy_Size
                .Top = Enemy_Data(L).Y - Enemy_Size
            Else
                .Visible = False
            End If
        End With
    Next
    
End Sub


'Ũ¥­¥ã¥é¥¯¥¿¡¼¥·¥ç¥Ã¥ÈÀ¸À®¥×¥í¥·¡¼¥¸¥ã

Sub E_Shot_Begin(X As Single, Y As Single, Typ As Long)
    
    Dim L As Long
    
    For L = 0 To 9
        With E_Shot_Data(L)
            If Not .Vis Then
                .X = X
                .Y = Y
                .Typ = Typ
                .Vis = True
                With UserForm1.Controls("E_Shot" & L + 1)
                    .Visible = True
                End With
                Exit For
            End If
        End With
    Next
    
End Sub


'Ũ¥­¥ã¥é¥¯¥¿¡¼¥·¥ç¥Ã¥È°Üư´ÉÍý¥×¥í¥·¡¼¥¸¥ã

Sub E_Shot_Action()

    Dim L As Long
    Dim LL As Long
    
    For L = 0 To 9
        With E_Shot_Data(L)
            If .Vis Then
                Select Case .Typ
                    Case 1
                        .Y = .Y + 4.5
                    Case 2
                        .X = .X + 0.5
                        .Y = .Y + 3.5
                    Case 3
                        .X = .X - 0.5
                        .Y = .Y + 3.5
                End Select
                If .X > 205 Then .Vis = 0
                If .Y > 205 Then .Vis = 0
                If .X < -5 Then .Vis = 0
                If .Y < -5 Then .Vis = 0
                If .X - 2 < Player_Data.X + Player_Data.W Then
                    If .X + 2 > Player_Data.X - Player_Data.W Then
                        If .Y - 2 < Player_Data.Y + Player_Data.H Then
                            If .Y + 2 > Player_Data.Y - Player_Data.H Then
                                .Vis = False
                                With Player_Data
                                    Call Burst_Begin(.X, .Y)
                                    .Lif = 0
                                End With
                            End If
                        End If
                    End If
                End If
                With UserForm1.Controls("E_Shot" & L + 1)
                    If E_Shot_Data(L).Vis Then
                        .Left = E_Shot_Data(L).X - Shot_Size
                        .Top = E_Shot_Data(L).Y - Shot_Size
                    Else
                        .Visible = False
                    End If
                End With
            End If
        End With
    Next
                
End Sub


'Çúȯ¥¨¥Õ¥§¥¯¥ÈÀ¸À®¥×¥í¥·¡¼¥¸¥ã

Sub Burst_Begin(X As Single, Y As Single)

    Dim L As Long
    
    For L = 0 To 2
        With Burst_Data(L)
            If .Par = 0 Then
                .X = X
                .Y = Y
                .W = Burst_Size
                .H = Burst_Size
                .Par = 1
                UserForm1.Controls("Burst" & L + 1).Visible = True
                Exit For
            End If
        End With
    Next
    
End Sub


'Çúȯ¥¨¥Õ¥§¥¯¥È´ÉÍý¥×¥í¥·¡¼¥¸¥ã

Sub Burst_Action()

    Dim L As Long
    Dim Pict As Long
    
    For L = 0 To 2
        With Burst_Data(L)
            If .Par > 0 Then
                Select Case .Par
                    Case 1
                        Pict = 1
                    Case 2, 3
                        Pict = 2
                    Case 4, 5
                        Pict = 3
                    Case 6, 7
                        Pict = 4
                    Case 8
                        Pict = 5
                    Case 9
                        .Par = -1
                End Select
                .Par = .Par + 1
                With UserForm1.Controls("Burst" & L + 1)
                    If Burst_Data(L).Par > 0 Then
                        .Left = Burst_Data(L).X - Burst_Size
                        .Top = Burst_Data(L).Y - Burst_Size
                        .Picture = UserForm1.Controls("Burst_s" & Pict).Picture
                    Else
                        .Visible = False
                    End If
                End With
            End If
        End With
    Next
                
End Sub


'ɸ½à¥â¥¸¥å¡¼¥ë¤Ï¤³¤³¤Þ¤Ç
'¤³¤³¤«¤é²¼¤Ï¥Õ¥©¡¼¥à¥â¥¸¥å¡¼¥ë¤Ëµ­½Ò


'¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤Î¥¯¥ê¥Ã¥¯¥¤¥Ù¥ó¥È

Private Sub Com_Start_Click()
    Com_Start.Enabled = False
    Call Main
    Unload UserForm1
End Sub


'¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Î¥¯¥¨¥ê¥¯¥í¡¼¥¹¥¤¥Ù¥ó¥È

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    End
End Sub


'¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Î¥¤¥Ë¥·¥ã¥é¥¤¥º¥¤¥Ù¥ó¥È
Private Sub UserForm_Initialize()
    UserForm1.Width = 220
End Sub



¤Á¤Ê¤ß¤Ë¡¢¤³¤³¤Þ¤Ç¤Î¾õÂÖ¤À¤È¡¢°ìÅÙ¥²¡¼¥à¥ª¡¼¥Ð¡¼¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤Ã¤Æ¤â¡¢¤ª¤«¤Þ¤¤¤Ê¤·¤Ç¥­¥ã¥é¥¯¥¿¡¼¤¬Åо줷³¤±¤Þ¤¹¡£¤Ä¤Þ¤ê¡¢¤Þ¤À̤´°À®¤È¤¤¤¦¤³¤È¤Ç¤¹¡£
¾­ÍèŪ¤Ë¤Ï¡¢¥²¡¼¥à¥ª¡¼¥Ð¡¼¤Ë¤Ê¤Ã¤¿¤é¥²¡¼¥à¤¬½ª¤ï¤Ã¤Æ¤·¤Þ¤¦¤è¤¦¤Ë¤·¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¤¬¡¢¤½¤ì¤Ï¤Þ¤¿¼¡²ó°Ê¹ß¡¢¤¬¤ó¤Ð¤Ã¤Æ¤ß¤ë¤³¤È¤Ë¤·¤Þ¤·¤ç¤¦¡£

¤Þ¤º¤Ï¡¢¥µ¥ó¥×¥ë¤ò¤´Í÷ĺ¤¯¤Ê¤ê¡¢¥³¡¼¥É¤ò¼«ÎϤÇÄ´À°¤¹¤ë¤Ê¤ê¤·¤Æ¤¤¤¿¤À¤¤¤Æ¡¢º£²ó¤Þ¤Ç¤ÎÆâÍÆ¤ò¼ÂÁõ¤µ¤»¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£



¥µ¥ó¥×¥ë¥À¥¦¥ó¥í¡¼¥É¡¡¢Í¡¡¥³¥Á¥é¤è¤ê¥À¥¦¥ó¥í¡¼¥É¤Ç¤­¤Þ¤¹¡£¡ÊÊÌ´Û¡Ë


¢£³Ê¸À

½çÈ֤˾ò·ï¤Ë±è¤Ã¤Æ¹Í¤¨¤ë
Á´ÂΤι½¿Þ¤ò¤è¤¯Íý²ò¤¹¤ë


¤ä¤äÊ£»¨¤Ç¤¹¤¬¡¢¤Ò¤È¤Ä¤Ò¤È¤Ä½çÈÖ¤ËÍý²ò¤¹¤ë¤³¤È¤¬ÂçÀڤǤ¹¡£






Comment

Name
E-mail
URL
Comment
Pass  *
Secret¡© ¡Ê´ÉÍý¼Ô¤Ë¤À¤±É½¼¨¡Ë

¥×¥í¥°¥é¥ß¥ó¥°´ØÏ¢¸¡º÷



¥×¥í¥°¥é¥ß¥ó¥°¤ä ExcelVBA ¤Ë´ØÏ¢¤·¤¿¸¡º÷¤Ë¤Ï¤³¤Á¤é¤ò¤É¤¦¤¾¡£

¥á¡¼¥ë¥Õ¥©¡¼¥à

±Æ»Â¤Ëʪ¿½¤¹¤È¤¤¤¦Êý¤Ï¤³¤Á¤é

̾Á°¡¡:
¥á¡¼¥ë:
·ï̾¡¡:
ËÜʸ¡¡:

²Äǽ¤Ê¸Â¤êÍ×˾¤Ë¤Ï±þ¤¨¤Þ¤¹¤¬¡¢É¬¤ºÊÖ¿®¤ä²óÅú¤¬¤Ç¤­¤ë¤³¤È¤ò¡¢Êݾ㤹¤ë¤â¤Î¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
¤´Î»¾µ¤¯¤À¤µ¤¤¡£

£Ã£è£á£ð£ô£å£ò£ó

¥³¥ó¥Æ¥ó¥Ä°ìÍ÷


¢£Chapter °ìÍ÷¢£
    Á´¤Æ¤ÎChapter¤Î°ìÍ÷¤Ç¤¹¡£
    Ä¾ÀÜ¥¢¥¯¥»¥¹¤·¤¿¤¤Êý¤Ï¤³¤Á¤é¤ò¤´ÍøÍѲ¼¤µ¤¤¡£

    £Ã£è£á£ð£ô£å£ò.£± [ ÃΤäƤª¤¯¤Ù¤­¿´ÆÀ ]
    £Ã£è£á£ð£ô£å£ò.£² [ £Å£ø£ã£å£ì¤Ã¤Æ¤Ê¤ó¤À¤í¤¦ ]
    £Ã£è£á£ð£ô£å£ò.£³ [ £Å£ø£ã£å£ì¤Î´ðËܲèÌÌ ]
    £Ã£è£á£ð£ô£å£ò.£´ [ £Ö£Â£Á¤È¤Ï¡© ]
    £Ã£è£á£ð£ô£å£ò.£µ [ ¥â¥¸¥å¡¼¥ë¤Ë¤Ä¤¤¤Æ ]
    £Ã£è£á£ð£ô£å£ò.£¶ [ ÊÑ¿ô ]
    £Ã£è£á£ð£ô£å£ò.£· [ ÊÑ¿ô¤Î·¿¤ÈÀë¸À ]
    £Ã£è£á£ð£ô£å£ò.£¸ [ ¥×¥í¥·¡¼¥¸¥ã¤È¥¹¥³¡¼¥× ]
    £Ã£è£á£ð£ô£å£ò.£¹ [ ¥²¡¼¥à¤Ä¤¯¤ëÍÍ¡¹¤Ê¼êË¡ ]
    £Ã£è£á£ð£ô£å£ò.£±£° [ ¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à ]
    £Ã£è£á£ð£ô£å£ò.£±£± [ ¥×¥í¥Ñ¥Æ¥£¥¦¥£¥ó¥É¥¦ ]
    £Ã£è£á£ð£ô£å£ò.£±£² [ Íð¿ô ]
    £Ã£è£á£ð£ô£å£ò.£±£³ [ ¾ò·ïʬ´ô ]
    £Ã£è£á£ð£ô£å£ò.£±£´ [ ¥²¡¼¥à²èÌ̤Υǥ¶¥¤¥ó ]
    £Ã£è£á£ð£ô£å£ò.£±£µ [ ¥³¡¼¥Éµ­½Ò¤Î´ðËܺîË¡ ]
    £Ã£è£á£ð£ô£å£ò.£±£¶ [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£± ̾Á°¤ò¤Ä¤±¤ë ]
    £Ã£è£á£ð£ô£å£ò.£±£· [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£² ¥Õ¥©¡¼¥à¤Îµ¯Æ° ]
    £Ã£è£á£ð£ô£å£ò.£±£¸ [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£³ Íð¿ô¤Î¼ï ]
    £Ã£è£á£ð£ô£å£ò.£±£¹ [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£´ ¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£²£° [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£µ °ú¿ô ]
    £Ã£è£á£ð£ô£å£ò.£²£± [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£¶ ÌòȽÄê ]
    £Ã£è£á£ð£ô£å£ò.£²£² [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£· ͽ¬¤ÈÀ©¸Â ]
    £Ã£è£á£ð£ô£å£ò.£²£³ [ With¥¹¥Æ¡¼¥È¥á¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£²£´ [ ²èÁü¤òɽ¼¨¤µ¤»¤ë ]
    £Ã£è£á£ð£ô£å£ò.£²£µ [ ²èÁüɽ¼¨¤ÎȯŸ·Á ]
    £Ã£è£á£ð£ô£å£ò.£²£¶ [ ·«¤êÊÖ¤·½èÍý Forʸ ]
    £Ã£è£á£ð£ô£å£ò.£²£· [ ·«¤êÊÖ¤·½èÍý Do¡ÁLoopʸ ]
    £Ã£è£á£ð£ô£å£ò.£²£¸ [ Exit¥¹¥Æ¡¼¥È¥á¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£²£¹ [ ¥Õ¥©¡¼¥à¾å¤Î°ÌÃÖ¾ðÊó ]
    £Ã£è£á£ð£ô£å£ò.£³£° [ API´ðÁÃÃμ± ]
    £Ã£è£á£ð£ô£å£ò.£³£± [ APIÊä­Ãμ± ]
    £Ã£è£á£ð£ô£å£ò.£³£² [ ¥á¥¤¥ó¥ë¡¼¥×¤ò¹Í¤¨¤ë ]
    £Ã£è£á£ð£ô£å£ò.£³£³ [ Ʊ´ü½èÍý¤Î³µÇ° ]
    £Ã£è£á£ð£ô£å£ò.£³£´ [ °Üư½èÍý¤½¤Î£±¡§²èÌÌÀßÄê¤È¹Í¤¨Êý ]
    £Ã£è£á£ð£ô£å£ò.£³£µ [ °Üư½èÍý¤½¤Î£²¡§DoEvents ]
    £Ã£è£á£ð£ô£å£ò.£³£¶ [ °Üư½èÍý¤½¤Î£³¡§¥­¡¼ÆþÎÏȽÄêAPI ]
    £Ã£è£á£ð£ô£å£ò.£³£· [ ¾ò·ïʬ´ô¤Î¤µ¤é¤Ê¤ëõµá Select Case ]
    £Ã£è£á£ð£ô£å£ò.£³£¸ [ ¥¢¥Ë¥á¡¼¥·¥ç¥ó ]
    £Ã£è£á£ð£ô£å£ò.£³£¹ [ ÇÛÎóÊÑ¿ô ]
    £Ã£è£á£ð£ô£å£ò.£´£° [ ¥²¡¼¥à¤Î½é´ü²½ ]
    £Ã£è£á£ð£ô£å£ò.£´£± [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±¡§¥²¡¼¥àÀß·× ]
    £Ã£è£á£ð£ô£å£ò.£´£² [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£²¡§¥á¥¤¥ó¥×¥í¥»¥¹ ]
    £Ã£è£á£ð£ô£å£ò.£´£³ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£³¡§¹½Â¤ÂÎ ]
    £Ã£è£á£ð£ô£å£ò.£´£´ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£´¡§Äê¿ô ]
    £Ã£è£á£ð£ô£å£ò.£´£µ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£µ¡§¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼ ]
    £Ã£è£á£ð£ô£å£ò.£´£¶ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£¶¡§¥·¥ç¥Ã¥È¤ò·â¤Ä­¡ ]
    £Ã£è£á£ð£ô£å£ò.£´£· [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£·¡§¥·¥ç¥Ã¥È¤ò·â¤Ä­¢ ]
    £Ã£è£á£ð£ô£å£ò.£´£¸ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£¸¡§Mod±é»»»Ò¤Î³èÍÑ ]
    £Ã£è£á£ð£ô£å£ò.£´£¹ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£¹¡§Å¨¥­¥ã¥é¥¯¥¿¡¼Åоì ]
    £Ã£è£á£ð£ô£å£ò.£µ£° [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£°¡§¾×ÆÍȽÄê ]
    £Ã£è£á£ð£ô£å£ò.£µ£± [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£±¡§¾×ÆÍ¤Î¼ÂÂÎ ]
    £Ã£è£á£ð£ô£å£ò.£µ£² [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£²¡§Å¨¤Î¹¶·â ]
    £Ã£è£á£ð£ô£å£ò.£µ£³ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£³¡§Çúȯ¥¨¥Õ¥§¥¯¥È ]
    £Ã£è£á£ð£ô£å£ò.£µ£´ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£´¡§»Äµ¡¿ôɽ¼¨­¡ ]
    £Ã£è£á£ð£ô£å£ò.£µ£µ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£µ¡§»Äµ¡¿ôɽ¼¨­¢ ]
    £Ã£è£á£ð£ô£å£ò.£µ£¶ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£¶¡§¥¹¥³¥¢¤Îɽ¼¨ ]
    £Ã£è£á£ð£ô£å£ò.£µ£· [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£·¡§¥¿¥¤¥È¥ë²èÌÌ ]
    £Ã£è£á£ð£ô£å£ò.£µ£¸ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£¸¡§¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼ ]
    £Ã£è£á£ð£ô£å£ò.£µ£¹ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£¹¡§ºÇ¸å¤Î»Å¾å¤²¤Ø ]
    £Ã£è£á£ð£ô£å£ò.£¶£° [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£²£°¡§¤¤¤è¤¤¤è´°À®STG ]
    £Ã£è£á£ð£ô£å£ò.£¶£± [ ¥«¡¼¥É¥²¡¼¥à¤Ç»È¤¨¤ë¤á¤¯¤ê¸ú²Ì ]
    £Ã£è£á£ð£ô£å£ò.£¶£² [ ¥é¥¸¥¢¥ó¤È³ÑÅÙ ]
    £Ã£è£á£ð£ô£å£ò.£¶£³ [ ¥é¥¸¥¢¥ó¤Î³èÍÑ¡§±ß±¿Æ° ]
    £Ã£è£á£ð£ô£å£ò.£¶£´ [ ¥é¥¸¥¢¥ó¤Î³èÍÑ¡§Ç¤°Õ¤Î³ÑÅÙ¤Ø°ÜÆ°¤¹¤ë ]
    £Ã£è£á£ð£ô£å£ò.£¶£µ [ API¤Ë¤è¤ë¥µ¥¦¥ó¥ÉºÆÀ¸¡§´ðÁà ]
    £Ã£è£á£ð£ô£å£ò.£¶£¶ [ API¤Ë¤è¤ë¥µ¥¦¥ó¥ÉºÆÀ¸¡§MIDI¤È¿½ÅºÆÀ¸ ]
    £Ã£è£á£ð£ô£å£ò.£¶£· [ API¤Ë¤è¤ë¥µ¥¦¥ó¥ÉºÆÀ¸¡§MCI¥³¥Þ¥ó¥É¤È¥ë¡¼¥×ºÆÀ¸ ]
    £Ã£è£á£ð£ô£å£ò.£¶£¸ [ Function ¥×¥í¥·¡¼¥¸¥ã ]
    £Ã£è£á£ð£ô£å£ò.£¶£¹ [ ÃÍÅϤ·¤È»²¾ÈÅϤ· ]
    £Ã£è£á£ð£ô£å£ò.£·£° [ ¥Ç¥Ð¥Ã¥°£±¡§¥¤¥ß¥Ç¥£¥¨¥¤¥È¥¦¥£¥ó¥É¥¦ ]
    £Ã£è£á£ð£ô£å£ò.£·£± [ ¥Ç¥Ð¥Ã¥°£²¡§¥í¡¼¥«¥ë¥¦¥£¥ó¥É¥¦ ]
    £Ã£è£á£ð£ô£å£ò.£·£² [ ¥Ç¥Ð¥Ã¥°£³¡§¥³¡¼¥É¼Â¹Ô¤ÎÃæÃÇ ]
    £Ã£è£á£ð£ô£å£ò.£·£³ [ ¥ª¥Ö¥¸¥§¥¯¥È¤Ã¤Æ¤Ê¤ó¤À ]
    £Ã£è£á£ð£ô£å£ò.£·£´ [ ¥×¥í¥Ñ¥Æ¥£¡¦¥á¥½¥Ã¥É¡¦¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£·£µ [ ¥ª¥Ö¥¸¥§¥¯¥ÈÊÑ¿ô ]
    £Ã£è£á£ð£ô£å£ò.£·£¶ [ ¥ª¥Ö¥¸¥§¥¯¥È¤È¥³¥ì¥¯¥·¥ç¥ó ]
    £Ã£è£á£ð£ô£å£ò.£·£· [ ÆÃ¼ì¤Ê·«¤êÊÖ¤·¡§For Each ]
    £Ã£è£á£ð£ô£å£ò.£·£¸ [ ¥¨¥é¡¼½èÍý ]
    £Ã£è£á£ð£ô£å£ò.£·£¹ [ On Error ¤È GoToʸ ]
    £Ã£è£á£ð£ô£å£ò.£¸£° [ Resume¥¹¥Æ¡¼¥È¥á¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£± [ ¥Ð¥¤¥È¤È¥Ó¥Ã¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£² [ ¥¦¥£¥ó¥É¥¦¥á¥Ã¥»¡¼¥¸¤È¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£³ [ ʸ»úÎó¤Î´ðÁà ]
    £Ã£è£á£ð£ô£å£ò.£¸£´ [ ʸ»úÎóÁàºî­¡ ]
    £Ã£è£á£ð£ô£å£ò.£¸£µ [ ʸ»úÎóÁàºî­¢ ]
    £Ã£è£á£ð£ô£å£ò.£¸£¶ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£±¡§»ÅÍͤò·è¤á¤ë ]
    £Ã£è£á£ð£ô£å£ò.£¸£· [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£²¡§¥­¡¼ÆþÎϸ¡ÃÎ ]
    £Ã£è£á£ð£ô£å£ò.£¸£¸ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£³¡§Ê¸»úÎó¾È¹ç ]
    £Ã£è£á£ð£ô£å£ò.£¸£¹ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£´¡§È½Äê´Ø¿ô ]
    £Ã£è£á£ð£ô£å£ò.£¹£° [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£µ¡§¥²¡¼¥à²èÌÌÀß·× ]
    £Ã£è£á£ð£ô£å£ò.£¹£± [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£¶¡§ÌäÂêʸ¤Î¥½¡¼¥È ]
    £Ã£è£á£ð£ô£å£ò.£¹£² [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£·¡§Æ°ÅªÇÛÎó ]
    £Ã£è£á£ð£ô£å£ò.£¹£³ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£¸¡§¥­¡¼¥À¥¦¥ó¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¹£´ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£¹¡§ÀµÂÇ¿ô¤Îɽ¼¨ ]
    £Ã£è£á£ð£ô£å£ò.£¹£µ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£±£°¡§¥¿¥¤¥à¤Îɽ¼¨ ]
    £Ã£è£á£ð£ô£å£ò.£¹£¶ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£±¡§¥¤¥Ù¥ó¥È¤Î¼ïÎà ]
    £Ã£è£á£ð£ô£å£ò.£¹£· [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£²¡§²èÌÌÀß·× ]
    £Ã£è£á£ð£ô£å£ò.£¹£¸ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£³¡§¥¯¥ê¥Ã¥¯ºÂɸ¸¡ÃÎ ]
    £Ã£è£á£ð£ô£å£ò.£¹£¹ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£´¡§¥­¥ã¥é¥¯¥¿¡¼½àÈ÷ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£° [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£µ¡§¥­¥ã¥é¥¯¥¿¡¼¤ÎÇÛÃÖ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£± [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£¶¡§¥­¥ã¥é¥¯¥¿¡¼°Üư¤ÈNot±é»»»Ò ]
    £Ã£è£á£ð£ô£å£ò.£±£°£² [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£·¡§¥¯¥ê¥Ã¥¯¤Î¥Ò¥Ã¥ÈȽÄê ]
    £Ã£è£á£ð£ô£å£ò.£±£°£³ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£¸¡§¥Ò¥Ã¥È¥Þ¡¼¥¯¥¨¥Õ¥§¥¯¥È ]
    £Ã£è£á£ð£ô£å£ò.£±£°£´ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£¹¡§¥µ¥¦¥ó¥É½èÍý¤Î¼ÂÁõ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£µ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£±£°¡§¥Þ¥¦¥¹¥«¡¼¥½¥ë¤ÎÊѹ¹ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£¶ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£±¡§»ÅÍͤȳµÍפò·è¤á¤ë ]
    £Ã£è£á£ð£ô£å£ò.£±£°£· [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£²¡§´ðËܳµÇ°¤Î³Îǧ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£¸ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£³¡§¥Ù¥¯¥È¥ë¤È¤Ï ]
    £Ã£è£á£ð£ô£å£ò.£±£°£¹ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£´¡§ÊÑ¿ô¤äÄê¿ô¤ÎÀë¸À ]
    £Ã£è£á£ð£ô£å£ò.£±£±£° [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£µ¡§½é´ü²½½èÍý¤Î¼ÂÁõ ]
    £Ã£è£á£ð£ô£å£ò.£±£±£± [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£¶¡§¥Ö¥í¥Ã¥¯¤ÎÇÛÃÖ ]
    £Ã£è£á£ð£ô£å£ò.£±£±£² [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£·¡§º¬´´½èÍý¤È¥Ð¡¼¤Î½èÍý ]
    £Ã£è£á£ð£ô£å£ò.£±£±£³ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£¸¡§Àþʬ¤ÈÀþʬ¤Î¸òº¹¤òȽÄê ]
    £Ã£è£á£ð£ô£å£ò.£±£±£´ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£¹¡§ÀþʬƱ»Î¤Î¸òÅÀ ]


    ¥³¡¼¥É¤äVBA¤Ë´Ø¤¹¤ë¼ÁÌä¤Ê¤É¤Ï¥µ¥Ý¡¼¥È·Ç¼¨ÈÄ¡ÊÊ̴ۡˤޤǤªµ¤·Ú¤Ë¤É¤¦¤¾¡£




fc2 seotool Excel VBA ¥²¡¼¥à ¥×¥í¥°¥é¥ß¥ó¥° ¹ÖºÂ

By FC2¥Ö¥í¥°

º£¤¹¤°¥Ö¥í¥°¤òºî¤í¤¦¡ª

Powered By FC2¥Ö¥í¥°

Counter

DigitalClock

¥×¥í¥Õ¥£¡¼¥ë

Author:
±Æ»Â
Excel¤ò¤³¤è¤Ê¤¯°¦¤¹¤ë¡£
DirectX¤òËܳÊŪ¤Ë»ÈÍѤ·¤¿VBA¥²¡¼¥à¤Î³«È¯¤ËÀ®¸ù¡£VBA¥²¡¼¥à³¦¤ÎȯŸ¤ò´ê¤¤¡¢Æü¡¹³èÆ°Ãæ¡£

edita


edita.jp¡Ú¥¨¥Ç¥£¥¿¡Û


From Omoituki

VBA ´ØÏ¢½ñÀÒ