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

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

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



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


£Ã£è£á£ð£ô£å£ò.£µ£¹ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£¹¡§ºÇ¸å¤Î»Å¾å¤²¤Ø ]

¢£¥³¡¼¥É¤Î½¤Àµ¤ÈÄɲÃ

Á°²ó¤Ë°ú¤­Â³¤­¡¢¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤Ë´Ø¤·¤Æ¤ä¤Ã¤Æ¤¤¤­¤Þ¤¹¡£
½¤Àµ¤¹¤ë²Õ½ê¤¬Â¿¤¯¤Ê¤ê¤Þ¤¹¤Î¤Ç¡¢¤Á¤ç¤Ã¤ÈÂçÊѤǤ¹¤¬´èÄ¥¤Ã¤Æ¤¤¤Ã¤Æ¤ß¤Þ¤·¤ç¤¦¡£

¤Þ¤º¤Ï¡¢Å¨¥­¥ã¥é¥¯¥¿¡¼¤Î½Ð¸½¤ò´ÉÍý¤·¤Æ¤¤¤ë¥×¥í¥·¡¼¥¸¥ã¡¢Stage_Count¤Î½¤Àµ¤«¤é¤Ç¤¹¡£

º£¤Î¾õÂ֤Ǥϡ¢¥²¡¼¥à¤ò»ß¤á¤ë¤Þ¤Ç¡¢±Ê±ó¤ËŨ¥­¥ã¥é¥¯¥¿¡¼¤¬½Ð¸½¤·Â³¤±¤ë»ÅÍͤˤʤäƤ¤¤Þ¤¹¡£¤³¤ì¤ò¡¢¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤¬Åо줹¤ë»ÅÍͤ˽¤Àµ¤·¤ÆÊѹ¹¤·¤Þ¤¹¡£

Sub Stage_Count()

    Dim TCMOD As Long
    
    Randomize
    
    TCMOD = Total_Count Mod 1000 '­¡
    
    If Total_Count < 2000 Then
        Select Case TCMOD
            Case 100, 150, 600, 650, 700, 750
                Call Enemy_Begin(Int(Rnd * 120) + 40, -10, 1)
            Case 200, 350, 450, 500, 800, 950
                Call Enemy_Begin(Int(Rnd * 120) + 40, -10, 2)
            Case 250, 300, 400, 550, 850, 900
                Call Enemy_Begin(Int(Rnd * 120) + 40, -10, 3)
        End Select
    Else
        If Total_Count = 2000 Then '­¢
            With Boss_Data
                .X = 100
                .Y = -20
                .W = 8
                .H = 8
                .Lif = 50
                .Par = 0
                .Typ = 0
            End With
            Boss_Begin = True '­£
            UserForm1.Boss.Visible = True
        End If
    End If
    
End Sub

¾å¤«¤é½çÈÖ¤ËÀâÌÀ¤·¤Þ¤¹¡£

¤Þ¤º­¡¤ÎÉôʬ¡£¥²¡¼¥à¤¬³«»Ï¤µ¤ì¤Æ¤«¤é¡¢£±²ó¥ë¡¼¥×¤¹¤ë¤´¤È¤ËÊÑ¿ôTotal_Count¤Ï¥×¥é¥¹£±¤º¤ÄÁý¤¨¤Æ¤¤¤­¤Þ¤¹¡£¤½¤·¤Æ¡¢¤³¤ÎÊÑ¿ô¤ÎÃͤò¸µ¤ËMod±é»»¤·¤¿·ë²Ì¤¬¡¢ÊÑ¿ôTCMOD¤ËÆþ¤ê¤Þ¤¹¡£

¤³¤³¤Ç¤Ï¡¢¡ØTCMOD = Total_Count Mod 1000¡Ù¤È¤¤¤¦ÂåÆþ¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢ÊÑ¿ôTCMOD¤ËÆþ¤ëÃͤϾï¤Ë£°¡Á£¹£¹£¹¤ÎÈϰϤËÀ©¸Â¤µ¤ì¤Þ¤¹¡£¤³¤³¤Þ¤Ç¤ÏÂç¾æÉפǤ¹¤«¡©
Mod±é»»»Ò¤ò»È¤Ã¤¿·×»»¤Ç¤Ï¡¢¡Ø½ü»»¤Î;¤ê¡Ù¤òÆÀ¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£¤Ä¤Þ¤ê¡¢¥ë¡¼¥×¤Î¤¿¤Ó¤Ë̵À©¸Â¤ËÁý¤¨Â³¤±¤ëÊÑ¿ôTotal_Count¤ò£±£°£°£°¤Ç³ä¤ë¤È¡¢¤½¤Î;¤ê¤Ï¡Ø³ä¤êÀڤ줿¾ì¹ç¤Î£°¡Ù¤«¤é¡Ø³ä¤êÀÚ¤ì¤Ê¤«¤Ã¤¿¾ì¹ç¤Î;¤ê£¹£¹£¹¡Ù¤Þ¤Ç¤Î´Ö¤Ë¤ª¤µ¤Þ¤ë¤È¤¤¤¦¤ï¤±¤Ç¤¹¤Í¡£
¤³¤Î;¤ê¤ò¤¦¤Þ¤¯ÍøÍѤ·¤Æ¡¢Select Case¤Ç¤Îʬ´ô¤ò¹Ô¤¤¤Ê¤¬¤é½èÍý¤ò¹Ô¤Ã¤Æ¤¤¤ë¤Î¤Ç¤¹¡£

¤½¤Î¼¡¤ÏÊÑ¿ôTotal_Count¤ÎÃͤ˱þ¤¸¤Æ½èÍý¤¬Ê¬¤«¤ì¤Þ¤¹¡£
¤â¤·¤â¡¢ÊÑ¿ôTotal_Count¤¬£²£°£°£°¤è¤ê¤â¾®¤µ¤¤¿ô¤À¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢¥¶¥³Å¨¥­¥ã¥é¥¯¥¿¡¼¤Î½Ð¸½½èÍý¤Ë°Ü¤ê¤Þ¤¹¡£¤³¤³¤Ç¤Ï¡¢Àè¤Û¤ÉÅо줷¤¿ÊÑ¿ôTCMOD¤ÎÃͤò¸µ¤Ë¥¶¥³Å¨¥­¥ã¥é¥¯¥¿¡¼¤ò½Ð¸½¤µ¤»¤Æ¤¤¤Þ¤¹¡£

¤½¤·¤Æ¡¢¤â¤·ÊÑ¿ôTotal_Count¤¬£²£°£°£°°Ê¾å¤Î¿ôÃͤˤʤ俾ì¹ç¡¢¤³¤³¤«¤é¤¬¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤Î½Ð¸½½èÍý¤Ç¤¹¡£¤³¤ì¤¬­¢¤ÎÉôʬ¤Ç¤¹¤Í¡£
¤³¤³¤Ç¤Ï¡¢ÊÑ¿ôTotal_Count¤¬£²£°£°£°¤Á¤ç¤¦¤É¤À¤Ã¤¿¾ì¹ç¤Ë¤À¤±¡¢¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤Î½Ð¸½½èÍý¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¡£¹½Â¤ÂΤγÆÍ×ÁǤˡ¢ÃͤòÀßÄꤷ¤Þ¤¹¡£

¤½¤·¤ÆºÇ¸å¤Ë­£¤ÎÉôʬ¤Ç¡¢ÊÑ¿ôBoss_Begin¤òTrue¤Ë¤·¤Æ¤¤¤Þ¤¹¡£¤³¤ì°Ê¹ß¤Ï¡¢¤³¤ÎÊÑ¿ô¤ò»²¾È¤¹¤ë¤³¤È¤Ë¤è¤Ã¤Æ¡¢¥Ü¥¹¤¬½Ð¸½¤·¤Æ¤¤¤ë¤È¤¤¤¦¤³¤È¤òȽÃǤ¹¤ë¤³¤È¤¬¤Ç¤­¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿¡£


¢£¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤Î´ÉÍý

¤µ¤Æ¡¢¼¡¤Ï¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤ò´ÉÍý¤¹¤ë¥×¥í¥·¡¼¥¸¥ã¤ÎºîÀ®¤Ç¤¹¡£¤³¤Á¤é¤Ï·ë¹½Ä¹¤¤¥×¥í¥·¡¼¥¸¥ã¤Ç¤¹¤¬¡¢º£¤Þ¤Ç¤ä¤Ã¤Æ¤­¤¿¤³¤È¤ò±þÍѤ·¤¿¤â¤Î¤Ë²á¤®¤Þ¤»¤ó¡£¤è¤¯¸«¤Æ¤Ò¤È¤Ä¤º¤ÄÍý²ò¤·¤Æ¤¤¤Ã¤Æ¤¯¤À¤µ¤¤¡£

Sub Boss_Action()

    Dim L As Long
    Dim LL As Long
    Dim S As Single
    Dim SS As Single
    
    Dim TCMOD
    
    Randomize
    
    TCMOD = Total_Count Mod 500
    
    With Boss_Data
        If .Lif > 0 Then
            If .Y < 30 Then '­¡
                .Y = .Y + 1
            Else
                If .Par > 0 Then
                    .X = .X + 2
                    If .X > 160 Then
                        .X = 160
                        .Par = 0
                    End If
                Else
                    .X = .X - 2
                    If .X < 40 Then
                        .X = 40
                        .Par = 1
                    End If
                End If
            End If
            Select Case TCMOD '­¢
                Case 50, 70, 90, 110, 130, 150
                    .Typ = 1
                Case 60, 80, 100, 140
                    .Typ = 2
                Case 80, 120, 160
                    .Typ = 3
                Case 200, 230, 260, 290, 320
                    .Typ = 4
                Case 350, 360, 370, 380, 390, 400, 410, 420, 430, 440, 450
                    .Typ = 5
                Case Else
                    .Typ = 0
            End Select
            If .Typ <> 0 Then Call E_Shot_Begin(.X, .Y + 5, .Typ)
        Else
            .Par = .Par + 1 '­£
            If .Par < 100 Then
                If .Par Mod 10 = 0 Then
                    S = Int(Rnd * 25) - 13
                    SS = Int(Rnd * 25) - 13
                    Call Burst_Begin(.X + S, .Y + SS)
                End If
            Else
                Game_Mode = 3 '­¤
                Boss_Begin = False
            End If
        End If
    End With
    With UserForm1.Boss
        If Boss_Begin Then
            .Left = Boss_Data.X - Boss_size
            .Top = Boss_Data.Y - Boss_size
        Else
            .Visible = False
        End If
    End With

End Sub

¤µ¤Æ¡¢­¡¤«¤é¸«¤Æ¤¤¤­¤Þ¤·¤ç¤¦¡£
­¡¤ÎÉôʬ¤«¤é¡¢¼¡¤Î­¢¤Þ¤Ç¤Î´Ö¤ÎÉôʬ¤Ç¤Ï¡¢¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤Î°Üư½èÍý¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¡£º£²ó¤Î¥³¡¼¥É¤Ç¤Ï¡¢Ã±½ã¤Ëº¸±¦¤Ë±ýÉü¤¹¤ë¤À¤±¤Îư¤­¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£

²èÌ̤γ°¤«¤é¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤¬Åо줷¡¢½Ä°ÌÃÖ¤¬£³£°¤òͤ¨¤ë¤Èº¸±¦±ýÉü¤Îư¤­¤Ø¤È°Ü¹Ô¤·¤Þ¤¹¡£¤½¤·¤Æº¸±¦±ýÉü¤Îưºî¤Ë°Ü¤Ã¤¿¤¢¤È¤Ï¡¢¹½Â¤ÂΤÎÍ×ÁÇPar¤Î¾õÂ֤ˤè¤Ã¤Æ¡¢º£¸½ºß¡¢º¸¤Ë¸þ¤«¤Ã¤ÆÆ°¤¤¤Æ¤¤¤ë¤Î¤«¡¢¤½¤ì¤È¤â±¦¤Ë¸þ¤«¤Ã¤ÆÆ°¤¤¤Æ¤¤¤ë¤Î¤«¤ò·è¤á¤Æ¤¤¤Þ¤¹¡£

¹½Â¤ÂΤÎÍ×ÁÇPar¤ÎÃͤ¬¡¢£°¤è¤êÂ礭¤¤(¤Ä¤Þ¤ê£±°Ê¾å)¤Î¤È¤­¤Ï¡¢¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤¬±¦¤Ë¸þ¤«¤Ã¤Æ°Üư¤·¤Þ¤¹¡£µÕ¤Ë¡¢£°°Ê²¼¤Î¿ôÃͤ¬ÀßÄꤵ¤ì¤Æ¤¤¤ë¤È¤­¤Ïº¸¤Ë¸þ¤«¤Ã¤Æ°Üư¤·¤Þ¤¹¡£

­¢¤ÎÉôʬ¤Ç¤Ï¡¢Å¨¥­¥ã¥é¥¯¥¿¡¼¤Î½Ð¸½´ÉÍý¤ÈƱ¤¸¼êË¡¤ò»È¤Ã¤Æ¡¢¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤Î¹¶·â¥Ñ¥¿¡¼¥ó¤òºî¤Ã¤Æ¤¤¤Þ¤¹¡£
Mod±é»»¤ò¤¦¤Þ¤¯³èÍѤ·¤Æ¤¤¤ë¤Î¤¬¤ï¤«¤ê¤Þ¤¹¤Í¡£
ÊÑ¿ôTCMOD¤ÎÃͤˤè¤Ã¤Æ¡¢Á´Éô¤Ç£µ¼ïÎà¤Î¥·¥ç¥Ã¥È¤òȯ¼Í¤¹¤ë¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£¤Á¤Ê¤ß¤Ë¡¢º£¤Ï¤Þ¤À¥·¥ç¥Ã¥È¤Î¼ïÎब£³¼ïÎष¤«ÄêµÁ¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡££´ÈÖÌܤȣµÈÖÌܤΥ·¥ç¥Ã¥È¤Ë¤Ä¤¤¤Æ¤Ï¡¢¼¡¤Î¹à¤Ç¤ä¤ê¤Þ¤¹¡£

¥·¥ç¥Ã¥È¤Ë¤Ä¤¤¤Æ¤Ï¤Á¤ç¤Ã¤ÈÃÖ¤¤¤È¤¤¤Æ¡¢¼¡¤Î­£¤ò¸«¤Æ¤ß¤Þ¤·¤ç¤¦¡£­£°Ê¹ß¤ÎÉôʬ¤Ç¤Ï¡¢¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤¬Ç˲õ¤µ¤ì¤¿¾ì¹ç¤Î½èÍý¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¡£¤³¤ì¤Ï¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤ÎÇúȯ¥¨¥Õ¥§¥¯¥È¤Î¤È¤­¤Ë¡¢¾Ü¤·¤¯»ÅÁȤߤò²òÀ⤷¤Þ¤·¤¿¤Í¡£(Chapter55¤ò»²¾È)¤¢¤ì¤ÈƱÍͤμêË¡¤Ç¤¹¡£
¤³¤³¤Ç¤Ï¡¢¥ë¡¼¥×¤¬£±£°£°²ó¤Þ¤ï¤ë¤Þ¤Ç¡¢£±£°¥ë¡¼¥×¤´¤È¤ËÇúȯ¥¨¥Õ¥§¥¯¥È¤òȯÀ¸¤µ¤»¤Æ¤¤¤Þ¤¹¡£¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤Ê¤Î¤Ç¡¢¤¿¤¯¤µ¤óÇúȯ¤¬µ¯¤³¤Ã¤¿¤Û¤¦¤¬¡¢¤½¤ì¤Ã¤Ý¤¤´¶¤¸¤¬¤¹¤ë¤Ç¤·¤ç¡©¡¡Â¿Ê¬¡Ä¡Ä¡£

¤½¤·¤ÆºÇ¸å¤Ë­¤¤ÎÉôʬ¡£¤³¤³¤Ç¤Ï¡¢¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤¬´°Á´¤Ë¾Ã¤¨¤¿¤È¤³¤í¤Ç¡¢¥²¡¼¥à¤Î¿Ê¹Ô¾õ¶·¤ò¡Ø¥²¡¼¥à¤Î¥¯¥ê¥¢¡Ù¤òɽ¤¹¾õÂÖ¤ËÊѹ¹¤·¤Æ¤¤¤Þ¤¹¡£¡ØGame_Mode = 3¡Ù¤ÎÉôʬ¤Ç¤¹¤Í¡£

¤³¤ì¤ò¤ä¤Ã¤Æ¤ª¤«¤Ê¤¤¤È¡¢¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤òÇ˲õ¤·¤¿¤Î¤Ë¡¢¥²¡¼¥à¤¬¥¯¥ê¥¢¤Ç¤­¤Ê¤¤¤È¤¤¤¦¾õÂ֤ˤʤäƤ·¤Þ¤¤¤Þ¤¹¡£Ëº¤ì¤º¤ËÀßÄꤷ¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£


¤µ¤Æ¡¢¤³¤ì¤Ç»Ä¤¹¤Ï¥·¥ç¥Ã¥È´ØÏ¢¤Î½èÍý¤À¤±¤Ç¤¹¡£
¥Ü¥¹¥­¥ã¥é¥¯¥¿¡¼¤ò´Þ¤á¤¿Å¨¥­¥ã¥é¥¯¥¿¡¼¤¬Êü¤Ä¥·¥ç¥Ã¥È¤Î½¤Àµ¡¢¤½¤·¤Æ¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬Êü¤Ä¥·¥ç¥Ã¥È¤Î½¤Àµ¡£¤³¤Î¤Õ¤¿¤Ä¤ò¹Ô¤¨¤Ð¡¢À²¤ì¤Æ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤¬´°À®¤·¤Þ¤¹¡£

ÆâÍÆÅª¤Ë¤«¤Ê¤ê½ÄĹ¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¤Î¤Ç¡¢¤³¤ì¤Ï¼¡²ó¤Ç¤¹¡£¤Á¤ç¤Ã¤È¤Þ¤É¤í¤Ã¤³¤·¤¤µ¤¤â¤·¤Þ¤¹¤¬¡¢º£²ó¤ÎÆâÍÆ¤ò¤Þ¤º¤Ï¤·¤Ã¤«¤êÍý²ò¤·¤Æ¤¯¤À¤µ¤¤¡£

ÌÜ¿·¤·¤¤µ»½Ñ¤ÏÆÃ¤Ë¤¢¤ê¤Þ¤»¤ó¡£Á´¤Æ¤¬º£¤Þ¤Ç¤Î±þÍѤˤʤäƤ¤¤Þ¤¹¡£°ì¸«¤¹¤ë¤È¤ï¤«¤ê¤Ë¤¯¤¤Éôʬ¤Ç¤â¡¢¤æ¤Ã¤¯¤ê½çÈ֤˾ò·ïʬ´ô¤Ê¤É¤òƧ¤Þ¤¨¤Æ¹Í¤¨¤Æ¤¤¤±¤Ð¡¢¤ª¤Î¤º¤È²¿¤ò¤ä¤í¤¦¤È¤·¤Æ¤¤¤ë¤Î¤«¤ï¤«¤ë¤Ï¤º¤Ç¤¹¡£¤³¤³¤Þ¤ÇÃÏÆ»¤Ë¿Ê¤á¤Æ¤­¤Æ¤¯¤À¤µ¤Ã¤Æ¤¤¤ì¤Ð¾°¹¹¤Ç¤¹¡£

¤¤¤­¤Ê¤ê¤³¤Î¥Ú¡¼¥¸¤«¤é¸«»Ï¤á¤Æ¤¤¤ëÊý¤Ë¤È¤Ã¤Æ¤Ï¡¢¤Á¤ç¤Ã¤ÈÆñ¤·¤¤ÆâÍÆ¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¡£¤ï¤«¤é¤Ê¤¤¤³¤È¤¬¤¢¤ì¤Ð¡¢É¬Íפ˱þ¤¸¤Æ²áµî¤Î¹ÖºÂ¤ËÌá¤Ã¤Æ¤ä¤Ã¤Æ¤ß¤ë¤È¤¤¤¤¤Ç¤·¤ç¤¦¡£¤Ê¤ó¤Ë¤·¤Æ¤â¾Ç¤ê¤Ï¶ØÊª¤Ç¤¹¡£¼«Ê¬¤Î¥ì¥Ù¥ë¤Ë¹ç¤ï¤»¤Æ¡¢¤ï¤«¤ë¤È¤³¤í¤«¤é¤¸¤Ã¤¯¤ê¼è¤êÁȤߤޤ·¤ç¤¦¡£


¼¡²ó¤Ï¤¤¤è¤¤¤è¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¹ÖºÂ¤ÎºÇ½ª²ó¡£¤¢¤È¾¯¤·¤À¤±¡¢´èÄ¥¤Ã¤Æ¤Û¤·¤¤¤È»×¤¤¤Þ¤¹¡£


¢£³Ê¸À

Mod±é»»»Ò¤ò³èÍѤ¹¤ë
¤ï¤«¤ë¤³¤È¤«¤é¥³¥Ä¥³¥Ä¤È


¼¡²ó¤Ï¤¤¤è¤¤¤è´°À®¤µ¤»¤Þ¤¹¡£
¼«Ê¬¤Ç¸À¤¦¤Î¤â¤Ê¤ó¤Ç¤¹¤¬¡¢Ä¹¤«¤Ã¤¿¤Ê¤¡¡Ä¡Ä¡£






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¥¹¥Æ¡¼¥È¥á¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£± [ ¥Ð¥¤¥È¤È¥Ó¥Ã¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£² [ ¥¦¥£¥ó¥É¥¦¥á¥Ã¥»¡¼¥¸¤È¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£³ [ ʸ»úÎó¤Î´ðÁà ]
    £Ã£è£á£ð£ô£å£ò.£¸£´ [ ʸ»úÎóÁàºî­¡ ]
    £Ã£è£á£ð£ô£å£ò.£¸£µ [ ʸ»úÎóÁàºî­¢ ]
    £Ã£è£á£ð£ô£å£ò.£¸£¶ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£±¡§»ÅÍͤò·è¤á¤ë ]
    £Ã£è£á£ð£ô£å£ò.£¸£· [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£²¡§¥­¡¼ÆþÎϸ¡ÃÎ ]
    £Ã£è£á£ð£ô£å£ò.£¸£¸ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£³¡§Ê¸»úÎó¾È¹ç ]
    £Ã£è£á£ð£ô£å£ò.£¸£¹ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£´¡§È½Äê´Ø¿ô ]


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




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

By FC2¥Ö¥í¥°

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

Powered By FC2¥Ö¥í¥°

Counter

DigitalClock

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

Author:
±Æ»Â
£Å£ø£ã£å£ì¤ò¤³¤è¤Ê¤¯°¦¤¹¤ë¤Ò¤È¡£
£²¡Á£³Ç¯¤Û¤ÉÁ°¤«¤é¡¢£Å£ø£ã£å£ì£Ö£Â£Á¤Ë¤è¤ë¥²¡¼¥à¥×¥í¥°¥é¥ß¥ó¥°¤ËÌܳФá¤ë¡£
ÆÀ°Õ¤Ê³«È¯Ê¬Ìî¤Ï¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à(¼«¾Î)¡£

IT¥Ö¥í¥°¥é¥ó¥­¥ó¥°

IT´ØÏ¢¤Î¥Ö¥í¥°ÀìÍÑ¥é¥ó¥­¥ó¥°¤Ç¤¹¡£ Îɤ«¤Ã¤¿¤é¤ò¥¯¥ê¥Ã¥¯¤ª´ê¤¤¤·¤Þ¤¹¡£

edita


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


From Omoituki