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

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

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



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


£Ã£è£á£ð£ô£å£ò.£µ£² [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£±£²¡§Å¨¤Î¹¶·â ]

¢£·Ñ¤®Â­¤··Ñ¤®Â­¤·

Á°²ó¤Î¹ÖºÂ¤Ç¡¢¥×¥ì¥¤¥ä¡¼¤ÎÊü¤Ã¤¿¥·¥ç¥Ã¥È¤ÈŨ¥­¥ã¥é¥¯¥¿¡¼¤Î¾×ÆÍȽÄ꤬´°À®¤·¤Þ¤·¤¿¡£¤À¤¤¤Ö¥²¡¼¥à¤é¤·¤¯¤Ê¤ê¤Þ¤·¤¿¤Í¡£

º£²ó¤Ï¡¢Å¨¥­¥ã¥é¥¯¥¿¡¼¤¬¹¶·â¤·¤Æ¤¯¤ë¤è¤¦¤Ë¤·¤Æ¤ß¤¿¤¤¤È»×¤¤¤Þ¤¹¡£
¼Â¤Ïº£²ó²òÀ⤹¤ëÆâÍÆ¤Ï¡¢º£¤Þ¤Ç¤ä¤Ã¤Æ¤­¤¿¤³¤È¤ÎÉü½¬¤ß¤¿¤¤¤Ê´¶¤¸¤Ë¤Ê¤ê¤Þ¤¹¡£¤Ê¤¼¤Ê¤é¡¢º£¤Þ¤Ç¾Ò²ð¤·¤Æ¤­¤¿¥Î¥¦¥Ï¥¦¤¬¤¢¤ì¤Ð¡¢Å¨¥­¥ã¥é¥¯¥¿¡¼¤¬¹¶·â¤·¤Æ¤¯¤ë»ÅÁȤߤòºî¤ë¤Î¤Ï¡¢¤±¤·¤ÆÆñ¤·¤¯¤Ê¤¤¤«¤é¤Ç¤¹¡£

¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬¥·¥ç¥Ã¥È¤ò·â¤Æ¤ë¤è¤¦¤Ë¤·¤¿¤È¤­¤ÈƱ¤¸¤è¤¦¤Ë¡¢¥×¥í¥·¡¼¥¸¥ã¤òÉôÉʲ½¤·¤Ê¤¬¤é¡¢Íî¤ÁÃ夤¤Æ½ñ¤­Â­¤·¤Æ¤¤¤±¤ÐÂç¾æÉפǤ¹¡£¤â¤·¤«¤·¤¿¤é¡¢¤â¤¦´û¤Ëºî¤Ã¤Æ¤·¤Þ¤Ã¤¿¤È¤¤¤¦¿Í¤â¡¢Ãæ¤Ë¤Ï¤¤¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤Í¡£
¥³¡¼¥É¤Î°ÕÌ£¤ä¹Í¤¨Êý¤Ê¤É¡¢ºÙ¤«¤ÊÉôʬ¤Ï´û¤ËÀâÌÀ¤·¤Æ¤¤¤ëÆâÍÆ¤¬¤Û¤È¤ó¤É¤Ç¤¹¡£º£²ó¤Ï´Êñ¤ÊÀâÌÀ¤òꤍ¤Ê¤¬¤é¡¢°ìµ¤¤Ëºî¤Ã¤Æ¤·¤Þ¤¤¤Þ¤·¤ç¤¦¡£


¢£ºàÎÁ¤ò½àÈ÷¤¹¤ë

¤½¤ì¤Ç¤Ï¡¢¤Þ¤º¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Ë¡¢Å¨¥·¥ç¥Ã¥ÈÍѤΥ¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ò½àÈ÷¤¹¤ë¤È¤³¤í¤«¤é»Ï¤á¤Þ¤·¤ç¤¦¡£

¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î»þ¤ÈƱÍͤˡ¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Ë¥³¥ó¥È¥í¡¼¥ë¤ò£±£°¸ÄÇÛÃÖ¤·¤Þ¤¹¡£²èÁü¤Ï¡¢²¼¤Î¾®¤µ¤¤ÀÄÃÆ¤ò»È¤¤¤Þ¤·¤ç¤¦¡£¤³¤ÎÀĤ¤ÃƤÏ8¡ß8¥Ô¥¯¥»¥ë¤Îgif²èÁü¤Ç¤¹¡£

Shot02.gif

¤³¤ì¤ò¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤ËÇÛÃÖ¤·¤¿¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Ë¥í¡¼¥É¤·¤Æ¤ª¤­¤Þ¤¹¡£8¥Ô¥¯¥»¥ë»ÍÊý¤Î²èÁü¤Ç¤¹¤«¤é¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ÎÂ礭¤µ( Width¡¦Height )¤Ï6¥Ý¥¤¥ó¥È¤Ë¤Ê¤ê¤Þ¤¹¡£¤³¤ì¤Ï¤â¤¦ÀâÌÀ¤·¤Ê¤¯¤Æ¤âÂç¾æÉפǤ¹¤Í¡£

290.gif

¤³¤³¤ÇÇÛÃÖ¤·¤¿£±£°¸Ä¤Î¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Ï¡¢Ì¾Á°¤òÊѹ¹¤¹¤ë¤Î¤ò˺¤ì¤º¤Ë¡£
º£²ó¤Ï¡¢Å¨¥­¥ã¥é¥¯¥¿¡¼ÍѤΥ·¥ç¥Ã¥È¤Ê¤Î¤Ç¡¢¡ØE_Shot1 ¡Á E_Shot10¡Ù¤Þ¤Ç¤ÎÏ¢ÈÖ¤Ç̾Á°¤ò¤Ä¤±¤Æ¤ª¤­¤Þ¤¹¡£

¤³¤ì¤Ç¡¢²èÌ̤νàÈ÷¤ÏOK¤Ç¤¹¡£
¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Î¿ô¤«¤é¤â¤ï¤«¤ë¤è¤¦¤Ë¡¢º£²ó¤Î¥²¡¼¥à¤Ç¤Ï¡¢Å¨¥­¥ã¥é¥¯¥¿¡¼¤Î¥·¥ç¥Ã¥È¤ÎºÇÂç¿ô¤ò£±£°¸Ä¤Ë¤·¤Þ¤¹¡£¤½¤ì¤òƧ¤Þ¤¨¤Æ¼¡¤Ë¿Ê¤ß¤Þ¤·¤ç¤¦¡£


¢£¥³¡¼¥É¤Îµ­½Ò

Ũ¤¬·â¤Æ¤ë¥·¥ç¥Ã¥È¤Î¿ô¤Ï£±£°¸Ä¤Ç¤¹¡£
¤½¤³¤Ç¡¢¤³¤ÎŨÍÑ¥·¥ç¥Ã¥È¤ò´ÉÍý¤¹¤ëÊÑ¿ô¤òÀë¸À¤·¤Þ¤¹¡£

Public E_Shot_Data(9) As Shot

ÊÑ¿ô¤Î·¿¤Ë»ÈÍѤ·¤Æ¤¤¤ë¡ØShot¡Ù¤Ï¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î¥·¥ç¥Ã¥È¤Ç»ÈÍѤ·¤¿¹½Â¤ÂÎ¤ÈÆ±¤¸¤â¤Î¤Ç¤¹¡£¤½¤Î¤Þ¤Þ»È¤¤¤Þ¤ï¤·¤Ç¤­¤Þ¤¹¡££±£°¸Ä¤Î¥Ç¡¼¥¿¤ò´ÉÍý¤¹¤ë¤Î¤Ç¡¢Í×ÁÇ¿ô£±£°¸Ä¤ÎÇÛÎó¤È¤·¤ÆÀë¸À¤·¤Æ¤¤¤Þ¤¹¡£

¤¤¤Ä¤â¤Î¥Ñ¥¿¡¼¥ó¤À¤È¡¢¤³¤³¤ÇÄê¿ô¤Ê¤É¤âÀë¸À¤·¤Þ¤¹¤Í¡£¤Ç¤âº£²ó¤ÏÁ´¤Æ¥×¥ì¥¤¥ä¡¼ÍѤΥ·¥ç¥Ã¥È¤ÇÀë¸À¤·¤¿¤â¤Î¤òήÍѤǤ­¤Þ¤¹¤«¤é¡¢²¼½àÈ÷¤Ï¤³¤ì¤Ç´°Î»¤Ç¤¹¡£´Êñ¤Ç¤¹¤Í¡£

¤µ¤Æ¡¢¥Æ¥ó¥Ý¤è¤¯¤¤¤­¤Þ¤·¤ç¤¦¡£¼¡¤Ï¥×¥í¥·¡¼¥¸¥ã¤Î½àÈ÷¤Ç¤¹¡£

¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬¥·¥ç¥Ã¥È¤ò·â¤Æ¤ë¤è¤¦¤Ë¤·¤¿¤È¤­¡¢¤É¤Î¤è¤¦¤Ë½èÍý¤·¤Æ¤¤¤¿¤«³Ð¤¨¤Æ¤¤¤ë¤Ç¤·¤ç¤¦¤«¡£
¥·¥ç¥Ã¥È¤Î¡ØÀ¸À®¡Ù¤È¡Ø°Üư¡Ù¤òʬ¤±¤Æ´ÉÍý¤·¤Æ¤¤¤¿¤ó¤Ç¤·¤¿¤Í¡£

¥·¥ç¥Ã¥ÈÀ¸À®¥×¥í¥·¡¼¥¸¥ã¤ò½àÈ÷¤¹¤ë
    ¢§
¥·¥ç¥Ã¥È¤Î°Üư´ÉÍý¥×¥í¥·¡¼¥¸¥ã¤ò½àÈ÷¤¹¤ë
    ¢§
Ǥ°Õ¤Î²Õ½ê¤Ç¡¢ºÂɸ¤ä¥¿¥¤¥×¤ò·è¤á¤Æ¡¢¥·¥ç¥Ã¥ÈÀ¸À®¥×¥í¥·¡¼¥¸¥ã¤ò¸Æ¤Ó½Ð¤¹

¥·¥ç¥Ã¥È¤ÎÀ¸À®¤È°Üư¤òʬ¤±¤Æ´ÉÍý¤¹¤ë¤³¤È¤Ç¡¢¤¢¤È¤¢¤ÈÈó¾ï¤Ë³Ú¤Ë¤Ê¤ê¤Þ¤¹¡£
Ũ¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤ò¹Ô¤Ã¤Æ¤¤¤ëºÇÃæ¤Ë¡¢°ìÄê¤Îµ¬Â§¤Ë¤Î¤Ã¤È¤Ã¤Æ¡Ø¥·¥ç¥Ã¥ÈÀ¸À®¥×¥í¥·¡¼¥¸¥ã¡Ù¤ò¸Æ¤Ó½Ð¤»¤Ð¡¢¤¢¤È¤Ï¾¡¼ê¤Ë¥·¥ç¥Ã¥È¤¬°Üư¤·¤Æ¤¤¤Ã¤Æ¤¯¤ì¤Þ¤¹¡£¥×¥í¥°¥é¥Þ¡¼¤Ç¤¢¤ë²æ¡¹¤Ï¡¢¤É¤Î¥¿¥¤¥ß¥ó¥°¤Ç¡¢¤É¤Î¥¿¥¤¥×¤Î¥·¥ç¥Ã¥È¤òȯ¼Í¤µ¤»¤ë¤«¡¢¤³¤ì¤À¤±¤ò¹Í¤¨¤ì¤Ð¤¤¤¤¤ï¤±¤Ç¤¹¤Í¡£

¤â¤Á¤í¤ó¡¢¥·¥ç¥Ã¥È¤Îµ°Æ»¤ò¶Å¤Ã¤¿¤â¤Î¤Ë¤·¤è¤¦¤È»×¤Ã¤¿¤é¡¢¥·¥ç¥Ã¥È¤Î°Üư¥×¥í¥·¡¼¥¸¥ã¤ò½¤Àµ¤·¤Ê¤¯¤Æ¤Ï¤¤¤±¤Þ¤»¤ó¡£¤Ç¤¹¤¬¡¢¤½¤Î¤è¤¦¤Ê¾ì¹ç¤Ç¤â¡¢µ°Æ»¤Î·×»»¤À¤±¤Ë½¸Ã椹¤ì¤Ð¤¤¤¤¤Ç¤¹¤«¤é¡¢µ¤»ý¤ÁŪ¤Ë¤â´ÉÍý¤¬³Ú¤Ë¤Ê¤ê¤Þ¤¹¡£


¤½¤ì¤Ç¤ÏÁᮥ³¡¼¥É¤ò¸«¤Æ¤¤¤­¤Þ¤·¤ç¤¦¡£

¤Þ¤º¤Ï¡Ø¥·¥ç¥Ã¥ÈÀ¸À®¥×¥í¥·¡¼¥¸¥ã¡Ù¤«¤é¤Ç¤¹¡£¤³¤ì¤Ï¡¢¹½Â¤Åª¤Ë¤Ï¤Û¤È¤ó¤É¥×¥ì¥¤¥ä¡¼ÍѤΤâ¤Î¤ÈƱ¤¸¤Ç¤¹¡£

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

¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤Ï°ú¿ô¤ò£³¤Ä¼è¤ê¤Þ¤¹¡£
¤Ò¤È¤Ä¤á¤Ï¡Ø X ¡Ä¡Ä²£°ÌÃÖ ¡Ù¡£¤Õ¤¿¤Ä¤á¤Ï¡Ø Y ¡Ä¡Ä½Ä°ÌÃÖ ¡Ù¡£¤½¤·¤Æ¤ß¤Ã¤Ä¤á¤¬¡Ø Typ ¡Ä¡Ä¥·¥ç¥Ã¥È¤Î¥¿¥¤¥× ¡Ù¤Î£³¤Ä¤Ç¤¹¤Í¡£

¤Þ¤º¤Ï¥×¥í¥·¡¼¥¸¥ã¤¬³«»Ï¤µ¤ì¤ë¤È¡¢Forʸ¤Ë¤è¤ë·«¤êÊÖ¤·½èÍý¤¬»Ï¤Þ¤ê¤Þ¤¹¡£¥·¥ç¥Ã¥È¤ò´ÉÍý¤¹¤ëÊÑ¿ôE_Shot_Data¤Î¡¢Í×ÁÇVis¤Î¾õÂÖ¤òÄ´¤Ù¤Æ¡¢ÆâÍÆ¤¬False¤À¤Ã¤¿¾ì¹ç(¥·¥ç¥Ã¥È¤¬¸«¤¨¤Æ¤¤¤Ê¤¤¡á¤Þ¤À·â¤¿¤ì¤Æ¤¤¤Ê¤¤)¤Ï¼¡¤Ë¿Ê¤ß¤Þ¤¹¡£¤³¤³¤¬­¡¤Ç¤¹¤Í¡£
ºÇ½é¤Ë°ú¿ô¤È¤·¤Æ¼õ¤±¼è¤Ã¤¿¥Ç¡¼¥¿¤ò¡¢­¢¤ÎÉôʬ¤ÇÊÑ¿ô¤Ë³ÊǼ¤·¤Þ¤¹¡£¤³¤³¤Ç³ÊǼ¤·¤¿¥Ç¡¼¥¿¤ò¸µ¤Ë¡¢¤³¤Î¼¡¤ËºîÀ®¤¹¤ë¡Ø¥·¥ç¥Ã¥È¤Î°Üư´ÉÍý¥×¥í¥·¡¼¥¸¥ã¡Ù¤¬½èÍý¤ò¹Ô¤¤¤Þ¤¹¤Î¤Ç¡¢¤³¤³¤Ç¤Ï­£¤Ç¼¨¤¹¤è¤¦¤Ë¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ÎVisible¥×¥í¥Ñ¥Æ¥£¤òTrue¤Ë¤·¤Æ¤ª¤±¤ÐÂç¾æÉפǤ¹¤Í¡£

¤½¤·¤Æ²¿µ¤¤ËÂçÀڤʤΤ¬­¤¤ÎÉôʬ¡£¤³¤³¤Ç¡ØExit For¡Ù¤ò»È¤Ã¤Æ·«¤êÊÖ¤·½èÍý¤òÈ´¤±¤Æ¤¤¤Þ¤¹¤Í¡£¤³¤¦¤·¤Æ¤ª¤«¤Ê¤¤¤È¡¢Èóɽ¼¨¤Î¥·¥ç¥Ã¥È¤¬Á´¤Æ°ìÅÙ¤Ëȯ¼Í¤µ¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¤Î¤ÇÃí°Õ¤·¤Þ¤·¤ç¤¦¡£


¼¡¤Ï¡Ø¥·¥ç¥Ã¥È¤Î°Üư´ÉÍý¥×¥í¥·¡¼¥¸¥ã¡Ù¤ò½àÈ÷¤·¤Þ¤¹¡£
¤³¤Á¤é¤Ï¡¢¤Á¤ç¤Ã¤È¥³¡¼¥É¤¬Ä¹¤¯¤Ê¤ê¤Þ¤¹¤¬¡¢Íî¤ÁÃ夤¤Æ¸«¤Æ¤¤¤±¤ÐÂç¾æÉפʤϤº¤Ç¤¹¡£ÃΤäƤª¤¯¤Ù¤­¤³¤È¤Ï´û¤Ë¤¹¤Ù¤Æ²òÀ⤷¤Æ¤¤¤Þ¤¹¡£

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
                                MsgBox "Hit!" '­¤
                            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

¤µ¤¡¤É¤¦¤Ç¤·¤ç¤¦¤«¡£¤Ê¤ó¤È¤Ê¤¯¤ä¤Ã¤Æ¤¤¤ë¤³¤È¤¬ÁÛÁü¤Ç¤­¤ë¤Ç¤·¤ç¤¦¤«¡£

Ũ¥­¥ã¥é¥¯¥¿¡¼ÍѤΥ·¥ç¥Ã¥È¤Ï£±£°¸Ä¤¢¤ê¤Þ¤¹¤«¤é¡¢¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤Ç¤â¤Þ¤º¤ÏForʸ¤Î·«¤êÊÖ¤·½èÍý¤¬»Ï¤Þ¤ê¤Þ¤¹¡£
¤½¤·¤Æ¡¢¥·¥ç¥Ã¥È¤¬¸«¤¨¤Æ¤¤¤ë¤«¤É¤¦¤«¡¢­¡¤ÇȽÃǤ·¤Æ¤¤¤Þ¤¹¤Í¡£¸«¤¨¤Æ¤¤¤Ê¤¤¾ì¹ç¤Ï²¿¤â¤»¤º¤ËÁÇÄ̤ꤷ¤Þ¤¹¡£¸«¤¨¤Æ¤¤¤ë¾ì¹ç¤Ï¡¢¤½¤Î¸å¤Î½èÍý¤Ë¿Ê¤ß¤Þ¤¹¡£
¤â¤·¤â¥·¥ç¥Ã¥È¤¬¸½ºß¸«¤¨¤Æ¤¤¤ë¾õÂÖ¤À¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢¤½¤Î¥·¥ç¥Ã¥È¤òư¤«¤µ¤Ê¤¯¤Æ¤Ï¤¤¤±¤Þ¤»¤ó¡£
º£²ó¤Ï¡¢Å¨ÍѤΥ·¥ç¥Ã¥È¤ò£³¼ïÎàÍѰդ·¤Æ¤ß¤Þ¤·¤ç¤¦¡£
¥·¥ç¥Ã¥È¤Î¥¿¥¤¥×¤Ë¤è¤Ã¤Æ¡¢°Üư¤Î»ÅÊý¤ò£³¼ïÎà¤ËʬÊ̤·¤Þ¤¹¡£
¥¿¥¤¥×£±¤Ï¡Ø¤Þ¤Ã¤¹¤°¿Ê¤à¥·¥ç¥Ã¥È¡Ù¡£¥¿¥¤¥×£²¤Ï¡Ø±¦¼Ð¤á²¼¤Ë¸þ¤«¤Ã¤Æ¿Ê¤à¥·¥ç¥Ã¥È¡Ù¤Ç¡¢¥¿¥¤¥×£³¤Ï¡Øº¸¼Ð¤á²¼¤Ë¸þ¤«¤Ã¤Æ¿Ê¤à¥·¥ç¥Ã¥È¡Ù¤Ë¤Ê¤ê¤Þ¤¹¡£²£°ÌÃÖ¤ä½Ä°ÌÃÖ¤ò¤É¤Î¤è¤¦¤ËÊѲ½¤µ¤»¤Æ¤¤¤ë¤«¤ò¤è¤¯¸«¤ì¤Ð¡¢¤ª¤Î¤º¤È¤ï¤«¤ë¤È»×¤¤¤Þ¤¹¡£

¼¡¤Ë­¢¤ÎÉôʬ¤Ç¡¢¥·¥ç¥Ã¥È¤¬²èÌ̤γ°¤Ë½Ð¤Æ¤·¤Þ¤Ã¤Æ¤¤¤Ê¤¤¤«¥Á¥§¥Ã¥¯¤·¤Æ¤¤¤Þ¤¹¡£¾å²¼º¸±¦Á´¤Æ¤ÎÊý¸þ¤Ç¥Á¥§¥Ã¥¯¤·¤Þ¤¹¡£

­£¤Ç¤Ï¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤È¤Î¡Ø¾×ÆÍȽÄê¡Ù¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¡£
°ì¸«¤¹¤ë¤ÈÊ£»¨¤Ë¸«¤¨¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡¢Ã±¤Ëʸ»ú¿ô¤¬¾¯¤·Â¿¤¤¤À¤±¤Ç¤¹¤«¤é¡¢Íî¤ÁÃ夤¤Æ·×»»¤·¤Þ¤·¤ç¤¦¤Í¡£É¬¤º¤ï¤«¤ë¤Ï¤º¤Ç¤¹¡£
¾×ÆÍȽÄê¤ò¹Ô¤Ã¤¿·ë²Ì¡¢¥·¥ç¥Ã¥È¤È¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬ÀÜ¿¨¤·¤Æ¤¤¤¿¾ì¹ç¤Ë¤Ï¡¢­¤¤ÎÉôʬ¤Ë½èÍý¤¬¿Ê¤ß¤Þ¤¹¡£
º£²ó¤Ï¡¢»ÃÄêŪ¤Ê½èÍý¤È¤·¤Æ¡¢¥á¥Ã¥»¡¼¥¸¤òɽ¼¨¤¹¤ë¤è¤¦¤Ë¤·¤Æ¤ª¤­¤Þ¤¹¡£ºÇ½ªÅª¤Ë¤Ï¡¢¤³¤³¤ÇÇúȯ¤Î¥¨¥Õ¥§¥¯¥È¤Ê¤É¤òÆþ¤ì¤Æ¡¢¥­¥ã¥é¥¯¥¿¡¼¤¬·âÄÆ¤µ¤ì¤Æ¤·¤Þ¤Ã¤¿¤è¤¦¤Ê±é½Ð¤Ë¤¹¤ëͽÄê¤Ç¤¹¡£º£¤Ï¥Æ¥¹¥ÈÃʳ¬¤È¤¤¤¦¤³¤È¤Ç¡¢¥á¥Ã¥»¡¼¥¸¤òɽ¼¨¤¹¤ë¤è¤¦¤Ë¤·¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£

¤½¤·¤Æ­¥¡¢¤³¤³¤Ï²èÌ̾å¤Î¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ò½èÍý¤·¤Æ¤¤¤ëÉôʬ¤Ç¤¹¤Í¡£
º£¤Þ¤Ç¾å¤Î¤Û¤¦¤Ç·×»»¤·¤Æ¤­¤¿¤Î¤Ï¡¢¤¢¤¯¤Þ¤Ç¤â¥Ç¡¼¥¿¾å¤Ç¤Î·×»»¤Ç¤¹¡£¤³¤ÎÉôʬ¤Ç¡¢¼ÂºÝ¤Ë¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ò°Üư¤·¤¿¤ê¡¢¾Ã¤·¤¿¤ê¤¹¤ë¤ï¤±¤Ç¤¹¡£

ºÙ¤«¤ÊÉôʬ¤Ç¤ï¤«¤é¤Ê¤¤¤³¤È¤¬¤¢¤ë¾ì¹ç¤Ï¡¢ÌÌÅݤǤ⡢°ÊÁ°¤ÎChapter¤ËÌá¤Ã¤ÆÉü½¬¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¤Í¡£¤ï¤«¤é¤Ê¤¤¤Þ¤Þ¿Ê¤á¤Æ¤·¤Þ¤¦¤È¡¢¤µ¤é¤Ë¤ï¤«¤é¤Ê¤¯¤Ê¤Ã¤Æ¤¤¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¤Î¤Ç¡£


¢£Å¨¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤ò½¤Àµ

¤µ¤Æ¡¢¥·¥ç¥Ã¥È¤Î¡ØÀ¸À®¡Ù¤È¡Ø°Üư¡Ù¤Ë´Ø¤¹¤ë½èÍý¤¬´°À®¤·¤Þ¤·¤¿¡£
¤¢¤È¤Ï¡¢¥·¥ç¥Ã¥È¤ò¼ÂºÝ¤Ëȯ¼Í¤¹¤ëŨ¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤òÊѹ¹¤·¤Þ¤¹¡£

¤È¤Ï¸À¤Ã¤Æ¤â¡¢¤¿¤Ã¤¿£±¹Ô¡¢½èÍý¤òÄɲ乤ë¤À¤±¤Ç¤¹¡£
¼¡¤Î¥³¡¼¥É¤ÇÎÐʸ»ú¤Ë¤Ê¤Ã¤Æ¤¤¤ëÉôʬ¡¢¤³¤Î£±¹Ô¤¬´Î¤Ç¤¹¤è¡£

Sub Enemy_Action()

    Dim L As Long
    Dim LL 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

¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤Î¾Ü¤·¤¤²òÀâ¤Ï¡¢°ÊÁ°¤Î¹ÖºÂ¤Ç¹Ô¤Ã¤Æ¤¤¤Þ¤¹¡£¤â¤·¤ï¤«¤é¤Ê¤¤¤È¤¤¤¦¿Í¤Ï¡¢¤½¤Á¤é¤ò¤´Í÷¤¯¤À¤µ¤¤(Chapter49¤ò»²¾È)¡£

º£²ó¤ÏÎФÎʸ»ú¤Çɽ¼¨¤µ¤ì¤Æ¤¤¤ëÉôʬ¤À¤±¡¢´Êñ¤Ë²òÀ⤷¤Þ¤¹¡£
¤³¤³¤Ç¤Ï¡¢Àè¤Û¤ÉºîÀ®¤·¤¿¡Ø¥·¥ç¥Ã¥ÈÀ¸À®¥×¥í¥·¡¼¥¸¥ã¡Ù¤ò¸Æ¤Ó½Ð¤·¤Æ¤¤¤Þ¤¹¡£¤¿¤À¤½¤ì¤À¤±¤Ç¤¹¡£¼ÂºÝ¡£

º£¸½ºß¤ÎŨ¥­¥ã¥é¥¯¥¿¡¼¤ÎºÂɸ¡¢¤½¤·¤Æ¡¢Å¨¥­¥ã¥é¥¯¥¿¡¼¤Î¥¿¥¤¥×¤ò¤½¤Î¤Þ¤Þ¥·¥ç¥Ã¥È¤Î¥¿¥¤¥×¤È¤·¤Æ¡¢°ú¿ô¤ËÅϤ·¤Æ¤¤¤Þ¤¹¡£
Ũ¥­¥ã¥é¥¯¥¿¡¼¤¬º£¸½ºß¤¤¤ëºÂɸ¾å¤Ë¡¢¥¿¥¤¥×¤Ë±þ¤¸¤Æ¥·¥ç¥Ã¥È¤¬À¸À®¤µ¤ì¤ë¤ï¤±¤Ç¤¹¡£
Ũ¤Î¥¿¥¤¥×¤Ë¤è¤Ã¤Æ¡¢¥·¥ç¥Ã¥È¤Î°Üư¤âϢư¤·¤ÆÊѲ½¤¹¤ë¤Î¤Ç¤¹¤Í¡£

¤Þ¤Ã¤¹¤°¿Ê¤à¥¿¥¤¥×¤ÎŨ¤Ï¡¢¤Þ¤Ã¤¹¤°¿Ê¤à¥·¥ç¥Ã¥È¤ò·â¤Á¤Þ¤¹¡£¼Ð¤á¤Ë°Üư¤¹¤ëŨ¤Ï¡¢¼Ð¤áÊý¸þ¤Ë¿Ê¤à¥·¥ç¥Ã¥È¤ò·â¤Á¤Þ¤¹¡£


¢£¤Þ¤È¤á¡¢Á´¥³¡¼¥É·ÇºÜ

¤½¤ì¤Ç¤ÏºÇ¸å¤Ë¡¢¤³¤³¤Þ¤Ç¤ÎÁ´¤Æ¤Î¥³¡¼¥É¤ò·ÇºÜ¤·¤Þ¤¹¡£
¤¤¤Ä¤â¤É¤ª¤ê¡¢Äɲä·¤¿Éôʬ¤Ï¿§¤¬ÊѤï¤Ã¤Æ¤¤¤Þ¤¹¡£¹ÖºÂ¤ò¸«¤Ê¤¬¤éºîÀ®¤·¤Æ¤¤¤ë¿Í¤Ï¡¢¿§¤ÎÊѲ½¤·¤Æ¤¤¤ëÉôʬ¤ËÃí°Õ¤·¤Ê¤¬¤é¡¢Å¬µ¹¥³¡¼¥É¤òÄɲ䷤Ƥߤޤ·¤ç¤¦¡£

¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤ÎÊý¤Î½àÈ÷¡¢³Æ¼ïÊÑ¿ô¤Î½é´ü²½¤òÄɲ乤뤳¤È¤â˺¤ì¤º¤Ë¡£

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

'¢¡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

'¡ü¥­¥ã¥é¥¯¥¿¡¼¡¡ÊÑ¿ôÀë¸À
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 Shot_Interval As Long
Public Total_Count 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
'Ũ¥­¥ã¥é¥¯¥¿¡¼¤Î¼ÂºÝ¤ÎÂ礭¤µ



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

Sub Init()
    With Player_Data
        .X = 100
        .Y = 180
        .W = 3
        .H = 3 '¥×¥ì¥¤¥ä¡¼¤ÎÆâÉôŪ¤ÊÂ礭¤µ
        .Lif = 1
        .Typ = 0
        .Par = 0
    End With
    Erase P_Shot_Data
    Erase E_Shot_Data
    Erase Enemy_Data
    Shot_Interval = 0
    Total_Count = 0
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
        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()

    With Player_Data

        '¥­¡¼ÆþÎÏȽÄê¤È°Üư½èÍý¡¡
        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, 0)
                Shot_Interval = 1
            End If
        Else
            Shot_Interval = Shot_Interval + 1
            If Shot_Interval > 7 Then Shot_Interval = 0
        End If

    End With

    '¥Õ¥©¡¼¥à¾å¤Î¡ØPlayer¡Ù¤ò¼ÂºÝ¤Ë°Üư¤¹¤ë½èÍý¡¡
    With UserForm1.Player
        .Left = Player_Data.X - Player_Size
        .Top = Player_Data.Y - Player_Size
    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)
                                            .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
                                MsgBox "Hit!"
                            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




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


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

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

¤¤¤ä¤¡¡Ä¡Ä¤³¤ì¤ÏŤ¤¤Ç¤¹¤Í¡£

¤Ç¤â¡¢½¤Àµ¤·¤Æ¤¤¤ë²Õ½ê¤Ë¹Ê¤Ã¤Æ¹Í¤¨¤ì¤Ð¡¢¤½¤ì¤Û¤É¤Ç¤â¤Ê¤¤¤Ï¤º¤Ç¤¹¡£
½é´ü²½½èÍý¤ä¡¢ÊÑ¿ô¤ÎÀë¸À²Õ½ê¤Ê¤É¤Ï˺¤ì¤ä¤¹¤¤¤Ç¤¹¤«¤éÃí°Õ¤·¤Þ¤·¤ç¤¦¡£

¤½¤ì¤«¤é¡¢Å¨¥­¥ã¥é¥¯¥¿¡¼¤È¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Ë¡¢¤¢¤¿¤êȽÄêÉôʬ¤òÀßÄꤷ¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¤Î¤Ç¡¢¥­¥ã¥é¥¯¥¿¡¼¹½Â¤ÂΤΡ¢Í×ÁÇ W ¤ÈÍ×ÁÇ H ¤ËÃͤòÀßÄꤹ¤ë¤Î¤â˺¤ì¤º¤Ë¤ä¤Ã¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£
¤³¤ì¤ò¤ä¤Ã¤Æ¤ª¤«¤Ê¤¤¤È¡¢¥­¥ã¥é¥¯¥¿¡¼¤È¥·¥ç¥Ã¥È¤Î¾×ÆÍ¤¬Àµ¤·¤¯È½Äꤵ¤ì¤Þ¤»¤ó¤Î¤Ç¤Í¡£


¤µ¤Æ¡¢¤É¤¦¤Ç¤¹¤«¡©¡¡³§¤µ¤ó¤¦¤Þ¤¯¤¤¤Ã¤¿¤Ç¤·¤ç¤¦¤«¡£
º£²ó¤Î¹ÖºÂ¤ÎÆâÍÆ¤ò¼ÂÁõ¤µ¤»¤¿¤é¡¢¸«¤¿Ìܾå¤Ï¤Û¤È¤ó¤É´°àú¤Ë¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤Ë¤Ê¤Ã¤¿¤Ï¤º¤Ç¤¹¡£
Ũ¤¬¹¶·â¤·¤Æ¤¯¤ë¡¢¤½¤ì¤òÈò¤±¤Ê¤¬¤é¥×¥ì¥¤¥ä¡¼¤¬¥·¥ç¥Ã¥È¤ò·â¤Ä¡Ä¡Ä¡£¤³¤ì¤Ï¤â¤¦¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤Î´ðÈפò¼ÂÁõ¤Ç¤­¤Æ¤¤¤ë¾õÂÖ¡¢¤È¸À¤Ã¤Æ¤¤¤¤¤Ç¤·¤ç¤¦¡£

¼ÂÁ©¹ÖºÂ£±¤È¤·¤Æ¡¢Á´£±£¹²ó¤Ë¤ï¤¿¤Ã¤Æ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤òºîÀ®¤·¤Æ¤­¤Þ¤·¤¿¡£¼ÂÁ©¹ÖºÂ£±¤Ï¡¢¤³¤ì¤Ë¤Æ½¤Î»¤È¤·¤Þ¤¹¡£¤³¤³¤Þ¤Ç¤¬¤ó¤Ð¤Ã¤Æ¤­¤¿³§¤µ¤ó¡¢¤ªÈè¤ìÍͤǤ·¤¿¡£
¤½¤·¤Æ¡¢Åö½é¤ÎÌó«¤Ç¤Ï¡¢¤â¤¦¾¯¤·¶Å¤Ã¤¿ÆâÍÆ¤Î¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤òºîÀ®¤¹¤ë¤³¤È¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤·¤¿¡£¤½¤ì¤é¤ÎȯŸ·Ïµ»½Ñ¤Ï¡¢¼ÂÁ©¹ÖºÂ£²¤È¤·¤Æ¡¢°ú¤­Â³¤­¤ªÁ÷¤ê¤·¤Æ¤¤¤¯Í½Äê¤Ç¤¹¡£

¼ÂÁ©¹ÖºÂ£²¤Ç¤Ï¡¢±é½Ð¤Ê¤É¤Îµ»½Ñ¤òÃæ¿´¤Ë¡¢¤µ¤é¤Ë¾å¤òÌܻؤ·¤Æ¼è¤êÁȤó¤Ç¤¤¤­¤Þ¤¹¡£
¼ÂÁ©¹ÖºÂ£±¤ÎÆâÍÆ¤ò¤·¤Ã¤«¤ê¤ÈÍý²ò¤·¡¢¤È¤ê¤¢¤¨¤º¡¢¤³¤³¤Þ¤Ç¤ò´°àú¤Ëºî¤Ã¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£¤Á¤ã¤ó¤ÈÍ·¤Ù¤ë¾õÂ֤ˤʤê¤Þ¤·¤¿¤Î¤Ç¡¢¤½¤ì¤Ê¤ê¤ÎãÀ®´¶¤âÌ£¤ï¤¨¤ë¤Ï¤º¤Ç¤¹¡£

¹ÖºÂÆâ¤Ç²¿ÅÙ¤â¸À¤Ã¤Æ¤¤¤Þ¤¹¤¬¡¢¥×¥í¥°¥é¥ß¥ó¥°¤Ë¸Â¤é¤º¡¢Á´¤Æ¤Î³Ø½¬¤Ï¡ØÄü¤á¤º¡Ù¤½¤·¤Æ¡Ø¼«Ê¬¤Î¥ì¥Ù¥ë¤Ë¹ç¤Ã¤¿¤â¤Î¤«¤é¼è¤êÁȤà¡Ù¤³¤È¤¬Èó¾ï¤ËÂçÀڤǤ¹¡£
¤è¤êÎɤ¤¤â¤Î¤ò´°À®¤µ¤»¤ë¤¿¤á¤Ë¤Ï¡¢¾Ç¤ê¤Ï¶ØÊª¤Ç¤¹¡£¤¸¤Ã¤¯¤ê¤æ¤Ã¤¯¤ê¤Ç¹½¤¤¤Þ¤»¤ó¡£¼«Ê¬¤Ë¤È¤Ã¤ÆºÇÎɤΥì¥Ù¥ë¤ÎÆâÍÆ¤ò¤·¤Ã¤«¤ê¸«¶Ë¤á¤Æ¡¢ÆÍ¤­¿Ê¤ó¤Ç¤¤¤Ã¤Æ¤¯¤À¤µ¤¤¤Í¡£

¤È¤ê¤¢¤¨¤º¡¢¤³¤³¤Þ¤ÇŤ¤¤³¤È¡¢ËÜÅö¤Ë¤ªÈè¤ìÍͤǤ·¤¿¡£


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


¢£³Ê¸À

ɬÍפ˱þ¤¸¤Æ²áµî¤Î¹ÖºÂ¤òÉü½¬
¾Ç¤é¤º¡¢¤½¤·¤ÆÄü¤á¤º¡ª


·ë¶ÉºÇ¸å¤Ï¤³¤ó¤Ê¤¢¤ê¤­¤¿¤ê¤Ê³Ê¸À¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡Ä¡Ä¡£
¼ÂÁ©¹ÖºÂ£²¤â¤ª³Ú¤·¤ß¤Ë¡£





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