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

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

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



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


£Ã£è£á£ð£ô£å£ò.£´£µ [ ¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à£µ¡§¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼ ]

¢£¤¤¤è¤¤¤è¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤Ø

¤µ¤Æ¡¢¤¤¤è¤¤¤è¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤Ç¤¹¡£¤³¤³¤Þ¤Ç¤¯¤ë¤Î¤¬·ë¹½ÂçÊѤǤ·¤¿¤Í¡£
¤·¤«¤·¡¢¥²¡¼¥à¤Ë¸Â¤é¤º¡¢¥×¥í¥°¥é¥à¤Ïº¬ËÜÉôʬ¤¬ºÇ¤âÂçÀڤǤ¹¡£¤³¤³¤Þ¤Ç¤ÎÆâÍÆ¤ò½ç¤Ë½¬ÆÀ¤·¤Æ¤­¤¿¤³¤È¤Ç¡¢³§¤µ¤ó¤Î¥¹¥­¥ë¤Ï³Î¼Â¤Ë¥¢¥Ã¥×¤·¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¤«¤é¡¢¤½¤³¤Ï¼«¿®¤ò»ý¤Ã¤Æ¤¤¤¤¤Ç¤·¤ç¤¦¡£

¤½¤ì¤Ç¤Ï¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤Ë¤Ä¤¤¤Æ¡¢¶ñÂÎŪ¤Ë¸«¤Æ¤¤¤¯¤³¤È¤Ë¤·¤Þ¤·¤ç¤¦¡£

¤½¤Î̾¤ÎÄ̤ꡢ¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Ï¡¢¥æ¡¼¥¶¡¼¤Ç¤¢¤ëÂè»°¼Ô¤¬¼«Í³¤ËÁàºî¤Ç¤­¤ë¥­¥ã¥é¥¯¥¿¡¼¤Ç¤Ê¤¯¤Æ¤Ï¤¤¤±¤Þ¤»¤ó¡£¤³¤ì¤ò¼Â¸½¤¹¤ë¤¿¤á¤Ë¤Ï¡¢°ÊÁ°¤Î¹ÖºÂ¤Ç²òÀ⤷¤¿¡Ø¥­¡¼¤ÎÆþÎÏȽÄê¡Ù¤¬É¬ÍפǤ¹(Chapter36¤ò»²¾È)¡£¤³¤³¤Þ¤Ç¤ÏÍÆ°×¤ËÁÛÁü¤¬¤Ä¤­¤Þ¤¹¤Í¡£
¤¢¤È¤Ï¡¢È½Äꤷ¤¿¥­¡¼¤Î¾õÂ֤˱þ¤¸¤Æ¡¢Å¬µ¹¥­¥ã¥é¥¯¥¿¡¼¤ò°Üư½èÍý¤·¤Æ¤¤¤±¤Ð¡¢¤½¤ì¤À¤±¤Ç´ðËÜŪ¤Ê¥­¥ã¥é¥¯¥¿¡¼½èÍýÉôʬ¤Ï´°À®¤·¤Þ¤¹¡£

¤³¤Î¡Ø¥­¡¼ÆþÎÏȽÄê¡Ü°Üư½èÍý¡Ù¤ò¼ÂÁõ¤µ¤»¤Æ¡¢¥×¥ì¥¤¥ä¡¼¤¬¼«Í³¤ËÁàºî¤¹¤ë¥­¥ã¥é¥¯¥¿¡¼¤òÍѰդ·¤Æ¤¤¤¯¤ï¤±¤Ç¤¹¤¬¡¢º£²óÂçÀڤʤΤϥ­¡¼ÆþÎϤä°Üư½èÍý°Ê³°¤ÎÉôʬ¤Ç¤¹¡£¥­¡¼ÆþÎÏȽÄê¤ÎºÙ¤«¤¤²òÀâ¤Ï°ÊÁ°¤Î¹ÖºÂ¤ò»²¾È¤·¤Æ¤¤¤¿¤À¤¯¤È¤·¤Æ¡¢º£²ó¤Ï¤½¤Î¾¤ÎÉôʬ¤Ç¡¢ÆÃ¤Ë½ÅÍפʳµÇ°¤òÃæ¿´¤Ë²òÀ⤷¤Þ¤¹¡£


¢£²èÌ̤«¤é¤Ï¤ß¤À¤µ¤»¤Ê¤¤

¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Î¥³¥ó¥È¥í¡¼¥ë¤Ï¡¢²èÌ̤«¤é¤Ï¤ß¤À¤·¤¿¤È¤³¤í¤Ë¸ºß¤¹¤ë¤³¤È¤â¤Ç¤­¤Þ¤¹¡£¤Ä¤Þ¤ê¸«¤¿Ìܾå¤Ï¸«¤¨¤Ê¤¤¾ì½ê¤Ë¡¢±£¤ì¤ÆÂ¸ºß¤¹¤ë¤³¤È¤¬¤Ç¤­¤ë¤È¤¤¤¦¤³¤È¤Ç¤¹¤Í¡£¤³¤ì¤Ï°Üư½èÍý¤Î¤È¤­¤ä¡¢½é´ü²½½èÍý¤Î¤È¤­¤Ë¤â¾¯¤·¿¨¤ì¤Þ¤·¤¿¡£

¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Îº¸¾å¤Î¥«¥É¤¬¡¢²£°ÌÃÖ¤â½Ä°ÌÃ֤⣰(¥¼¥í)¤Î¾ì½ê¡£°ÌÃÖ¾ðÊó¤Ë¥Þ¥¤¥Ê¥¹¤Î¿ôÃͤò»ØÄꤹ¤ì¤Ð¡¢¤¤¤º¤ì¸«¤¨¤Ê¤¯¤Ê¤Ã¤Æ¤·¤Þ¤¦¤Î¤Ç¤·¤¿¤Í¡£
¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤¬²£Éý£±£°£°¥Ý¥¤¥ó¥È¤·¤«¤Ê¤¤¤Î¤Ë¡¢¤½¤ì°Ê¾å¤Î¿ôÃͤò»ØÄꤷ¤¿¾ì¹ç¤Ë¤âƱÍͤΤ³¤È¤¬µ¯¤³¤ê¤Þ¤¹¡£

¤³¤Î»ÅÁȤߤϡ¢¸«¤»¤¿¤¯¤Ê¤¤¤â¤Î¤ò±£¤·¤¿¤ê¤¹¤ë¤È¤­¤Ë¤ÏÊØÍø¤Ç¤¹¡£¤Ç¤¹¤¬¡¢¥­¥ã¥é¥¯¥¿¡¼¤òɽ¼¨¤¹¤ë¤È¤­¤È¤Ê¤ë¤È¡¢¤Þ¤¿Ï䬰㤤¤Þ¤¹¡£

º£²ó¤Î¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤Ç¤Ï¡¢²èÌ̾夫¤é¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬¾Ã¤¨¤Æ¤·¤Þ¤Ã¤Æ¤Ïº¤¤ê¤Þ¤¹¡£¤«¤Îͭ̾¤Ê¥Þ¥ê¥ª¥Ö¥é¥¶¡¼¥º¤¸¤ã¤¢¤ë¤Þ¤¤¤·¡¢±¦¤«¤é½Ð¤Æ¹Ô¤¯¤Èº¸¤«¤é½Ð¤Æ¤¯¤ë¤Ê¤ó¤Æ¤ï¤±¤Ë¤Ï¤¤¤­¤Þ¤»¤ó¡£(¤½¤¦¤¤¤¦À߷פˤ¹¤ë¾ì¹ç¤ÏÊ̤Ǥ¹¤¬)

¤½¤³¤Ç¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤ÎÃæ¤Ç¡¢²èÌ̤«¤é¤Ï¤ß¤À¤µ¤»¤Ê¤¤¤¿¤á¤Î»ÅÁȤߤò¼ÂÁõ¤·¤Æ¤ª¤¯É¬Íפ¬¤¢¤ê¤Þ¤¹¡£
¥­¥ã¥é¥¯¥¿¡¼¤¬º£¤É¤³¤Ë¤¤¤ë¤«¡¢¤½¤·¤Æ¡¢²èÌ̤ÎÂ礭¤µ¤È¥­¥ã¥é¥¯¥¿¡¼¤ÎÂ礭¤µ¤Ï¤É¤ì¤¯¤é¤¤¤«¡¢¤³¤Î¹ç·×£³¤Ä¤Î¾ðÊ󤬤¢¤ì¤Ð¡¢¤Ï¤ß¤À¤·Ëɻ߽èÍý¤ò¹Ô¤¦¤³¤È¤¬¤Ç¤­¤ë¤Ï¤º¤Ç¤¹¡£

¥­¥ã¥é¥¯¥¿¡¼¤ò¤Ï¤ß¤À¤µ¤»¤Ê¤¤¤¿¤á¤Ë
­¡¥­¥ã¥é¥¯¥¿¡¼¤Î°ÌÃ֤Ϥɤ³¤«¡©
­¢¥­¥ã¥é¥¯¥¿¡¼¤ÎÂ礭¤µ¤Ï¤É¤ì¤¯¤é¤¤¤«¡©
­£¥²¡¼¥à²èÌ̤ÎÂ礭¤µ¤Ï¤É¤ì¤¯¤é¤¤¤«¡©


¢£°Üư½èÍý¤È¤Ï¤ß¤À¤·Ëɻ߽èÍý

¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤ò´ÉÍý¤¹¤ë¥×¥í¥·¡¼¥¸¥ã¤Ï¡¢¸½Ãʳ¬¤Ç¤Ï¡¢¼¡¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£¤¤¤­¤Ê¤ê¾¯¤·Ä¹¤á¤Î¥³¡¼¥É¤¬½Ð¤Æ¤­¤Æ¤·¤Þ¤¤¤Þ¤¹¤¬¡¢¸å¤«¤é¤æ¤Ã¤¯¤ê¤¸¤Ã¤¯¤ê²òÀ⤷¤Þ¤¹¤Î¤Ç¡¢¤È¤ê¤¢¤¨¤º¸«¤Æ¤¯¤À¤µ¤¤¡£

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

    End With

    '¥Õ¥©¡¼¥à¾å¤Î¡ØPlayer¡Ù¤ò¼ÂºÝ¤Ë°Üư¤¹¤ë½èÍý¡¡¡§­£
    With UserForm1.Player
        .Left = Player_Data.X - Player_Size
        .Top = Player_Data.Y - Player_Size
    End With

End Sub

¤³¤ì¤¬¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤òôÅö¤¹¤ë¡ØPlayer_Action¥×¥í¥·¡¼¥¸¥ã¡Ù¤Ç¤¹¡£
¸½Ãʳ¬¤Ç¤Ï¡¢°Üư½èÍý¤È¡¢¤Ï¤ß¤À¤·Ëɻ߽èÍý¤¬»Ü¤µ¤ì¤Æ¤¤¤ë¾õÂ֤Ǥ¹¤Í¡£

­¡¤ÎÉôʬ¤¬¡¢¡Ø°Üư½èÍý¡Ù¤ò¹Ô¤Ã¤Æ¤¤¤ëÉôʬ¤Ç¤¹¡£
¸«¤Æ¤ï¤«¤ë¤È¤ª¤ê¡¢GetAsyncKeyState´Ø¿ô¤ò»È¤Ã¤Æ¡¢£´Êý¸þÁ´¤Æ¤Î¥­¡¼ÆþÎϤòȽÄꤷ¤Æ¤¤¤Þ¤¹¡£¤â¤·¤â¥«¡¼¥½¥ë¤Îº¸¥­¡¼¤¬²¡¤µ¤ì¤Æ¤¤¤¿¾ì¹ç¤Ë¤Ï¡¢²£°ÌÃÖ¤òɽ¤¹¡ØÍ×ÁÇ X ¡Ù¤ÎÃͤò¥Þ¥¤¥Ê¥¹¤·¤Þ¤¹¡£²£°ÌÃÖ¤ÎÄêµÁ¤Ïº¸¤Ë¹Ô¤¯¤Û¤É¥Þ¥¤¥Ê¥¹¡¢±¦¤Ë¹Ô¤¯¤Û¤É¥×¥é¥¹¤Ç¤·¤¿¤Í¡£º¸¥­¡¼¤¬²¡¤µ¤ì¤Æ¤¤¤ë¤Ê¤é¡¢Í×ÁÇ X ¤Ï¥Þ¥¤¥Ê¥¹¤µ¤ì¤ë¤ï¤±¤Ç¤¹¡£
¤â¤·¤â¡¢±¦Êý¸þ¤¬²¡¤µ¤ì¤Æ¤¤¤ë¤Ê¤é¡¢Àè¤Û¤É¤È¤ÏÈ¿ÂÐÊý¸þ¤Ê¤Î¤Ç¡¢Í×ÁÇ X ¤ò¥×¥é¥¹¤¹¤ì¤Ð¤¤¤¤¤Î¤Ç¤¹¤Í¡£

ƱÍͤˡ¢½Ä°ÌÃ֤ξðÊó¤â½èÍý¤·¤Þ¤¹¡£½Ä°ÌÃÖ¤ÎÄêµÁ¤Ç¤Ï¡¢¾å¤Ë¹Ô¤¯¤Û¤É¥Þ¥¤¥Ê¥¹¡£²¼¤Ë¹Ô¤¯¤Û¤É¥×¥é¥¹¤Ç¤¹¡£¹Í¤¨Êý¤Ï²£°ÌÃ֤ΤȤ­¤ÈÁ´¤¯Æ±¤¸¤Ç¤¹¡£

­¢¤Ç¤Ï¡Ø¤Ï¤ß¤À¤·Ëɻ߽èÍý¡Ù¤ò¤·¤Æ¤¤¤Þ¤¹¡£
¥²¡¼¥à²èÌ̤ÎÌò³ä¤ò²Ì¤¿¤·¤Æ¤¤¤ë¡¢¥Õ¥ì¡¼¥à¥³¥ó¥È¥í¡¼¥ë¤ÎÂ礭¤µ¤Ï¡¢½Ä²£¤¤¤º¤ì¤â£²£°£°¥Ý¥¤¥ó¥È¤À¤Ã¤¿¤Ï¤º¤Ç¤¹¡£¤È¤¤¤¦¤³¤È¤Ï¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬¡¢¤³¤ì¤è¤ê¤â³°¤ÎÈϰϤ˽ФƹԤäƤ·¤Þ¤ï¤Ê¤¤¤è¤¦¤Ë¡¢Ãà°ì´Æ»ë¤·¤Ê¤¯¤Æ¤Ï¤¤¤±¤Þ¤»¤ó¡£

ÊÑ¿ôPlayer_Data¤Î¡¢Í×ÁÇ X ¤È¡¢Í×ÁÇ Y ¤Ï¡¢¥­¥ã¥é¥¯¥¿¡¼¤ÎÃæ¿´¤«¤é¸«¤¿°ÌÃÖºÂɸ¤òɽ¤·¤Æ¤¤¤Þ¤¹¡£
¼¡¤Î²èÁü¤Ç¸À¤¨¤Ð¡¢²«¿§¤¯¥Þ¡¼¥¯¤µ¤ì¤Æ¤¤¤ëÉôʬ¤Ç¤¹¡£

240.gif

¤·¤«¤·¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Ç¤Î°ÌÃÖ¤òɽ¤¹¥×¥í¥Ñ¥Æ¥£¡ØTop¡¦Left¡Ù¤Ï¡¢Ãæ¿´¤Ç¤Ï¤Ê¤¯¡Øº¸¾å¤ÎºÂɸ¡Ù¤Ç°ÌÃÖ¾ðÊó¤òɽ¤·¤Þ¤¹¡£

241.gif

¤³¤Î¤è¤¦¤Ë¡¢ÊÑ¿ôPlayer_Data¤Ç¤ÎºÂɸ¤È¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤ÎºÂɸ¤Ç¤Ï¡¢ºÂɸ°ÌÃ֤ιͤ¨Êý¤¬°ã¤Ã¤Æ¤¤¤Þ¤¹¡£É½¼¨¤¹¤ë°ÌÃÖ¤òÀµ¤·¤¯·×»»¤¹¤ë¤¿¤á¤Ë¤Ï¡¢¤³¤³¤Ç½Ð¤Æ¤¤¤ëºÂɸ¾å¤Îº¹¤ò¹Íθ¤·¤Æ¡¢Å¬ÀڤʽèÍý¤ò¹Ô¤ï¤Ê¤¯¤Æ¤Ï¤¤¤±¤Þ¤»¤ó¡£

¤³¤³¤Ç¡¢Á°²ó²òÀ⤷¤¿¡¢¡ØÄê¿ô¡Ù¤¬Ìò¤ËΩ¤Á¤Þ¤¹¡£

Á°²ó¡¢½é´ü²½½èÍý¤Î¥³¡¼¥É¤ÎÃæ¤Ç¡ØÄê¿ôPlayer_Size¡Ù¤òÀë¸À¤·¤Þ¤·¤¿¡£¤³¤ÎÄê¿ôPlayer_Size¤Ï¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Î¼ÂºÝ¤ÎÉý¤ò¤¢¤é¤«¤¸¤áÀßÄꤷ¤Æ¤¤¤Þ¤·¤¿¤Í¡£³Ð¤¨¤Æ¤¤¤ë¤Ç¤·¤ç¤¦¤«¡£

Public Const Player_Size As Single = 9

Á°²ó¤Î¥³¡¼¥ÉÆâ¤Î¥³¥á¥ó¥È¤Ç¡Ø¤¢¤È¤Ç»È¤¤¤ä¤¹¤¤¤è¤¦¤Ë£²Ê¬¤Î£±¤Ë¤·¤Æ¤ª¤¯¡£¼ÂºÝ¤Ï18¥Ý¥¤¥ó¥È¤Ê¤Î¤Ç9¤òÀßÄê¡Ù¤È½ñ¤¤¤Æ¤¢¤ê¤Þ¤·¤¿¡£¼Â¤Ï¡¢£²Ê¬¤Î£±¤Ë¤¹¤ëÍýͳ¤Ï¡¢¤³¤Î¸å¤ÎºÂɸÊÑ´¹¤Î¹Í¤¨Êý¤ò¤è¤¯¸«¤Æ¤ß¤ë¤È¡¢¤ª¤Î¤º¤È¤ï¤«¤ê¤Þ¤¹¡£

242.gif

¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¼«ÂΤÎÂ礭¤µ¤Ï¡Ø18¥Ý¥¤¥ó¥È¡Ù¤Ç¤·¤¿¤Í¡£¤½¤·¤Æ¡¢Äê¿ôPlayer_Size¤Ë¤Ï¡¢¤½¤ÎȾʬ¤Î¡Ø 9 ¡Ù¤ò¤¢¤é¤«¤¸¤á³ÊǼ¤·¤Æ¤¢¤ê¤Þ¤¹¡£
¤Ê¤¼£²Ê¬¤Î£±¤Î¿ôÃͤò³ÊǼ¤·¤¿¤Î¤«¤Ï¡¢¾å¤Î²èÁü¤Ç¹Í¤¨¤Æ¤ß¤ë¤È¤ï¤«¤ë¤È»×¤¤¤Þ¤¹¡£

¤³¤Î»ÅÁȤߤ¬Íý²ò¤Ç¤­¤Æ¤¤¤ë¤È¡¢¥­¥ã¥é¥¯¥¿¡¼¤Î¾å²¼º¸±¦¤ÎÊÕ¤¬¡¢¤É¤ÎºÂɸ¤Ë¤Ê¤ë¤«µá¤á¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£

¥­¥ã¥é¥¯¥¿¡¼¤Î¾å²¼º¸±¦¤ÎºÂɸ¤Ï¡Ä¡Ä

º¸ÊÕ¡§ X - 9
¾åÊÕ¡§ Y - 9
±¦ÊÕ¡§ X + 9
²¼ÊÕ¡§ Y + 9

¤Çµá¤á¤ë¤³¤È¤¬¤Ç¤­¤ë

¤³¤Î¹Í¤¨Êý¤ò¸µ¤Ë¡¢¥­¥ã¥é¥¯¥¿¡¼¤¬º¸¤Îü¤ËÍè¤Æ¤¤¤ë¤È¤­¤Ï¡¢¤½¤ì°Ê¾å¤á¤ê¹þ¤á¤Ê¤¤¤è¤¦¤Ë¡Ä¡Ä¾å¤Îü¤ËÍè¤Æ¤¤¤ë¤È¤­¤Ï¡¢¤½¤ì°Ê¾å¤á¤ê¹þ¤á¤Ê¤¤¤è¤¦¤Ë¡Ä¡Ä¤È¡¢£´¤Ä¤ÎÊý¸þÁ´¤Æ¤ò¥Á¥§¥Ã¥¯¤·¤Þ¤¹¡£¤³¤ì¤¬¡¢Àè¤Û¤ÉºÜ¤»¤¿¥³¡¼¥É¤Î­¢¤ÎÉôʬ¤Ç¤¹¡£

¤â¤·¡¢¥Õ¥ì¡¼¥à¤Îü¤è¤ê¤â³°Â¦¤Ë½Ð¤Æ¤¤¤¿¤È¤­(¤Ä¤Þ¤ê³ÆÊÕ¤¬£°¤è¤ê¾®¤µ¤¤¤«¡¢¤¢¤ë¤¤¤Ï£²£°£°¤è¤êÂ礭¤¤¤È¤­)¤Ï¡¢¶¯À©Åª¤ËºÂɸ¤òü¤ÎÉôʬ¤Ë¹ç¤ï¤»¤Æ¤·¤Þ¤¦¤ï¤±¤Ç¤¹¡£¤³¤ì¤Ç¡¢¤Ï¤ß¤À¤·Ëɻ߽èÍý¤¬¼ÂÁõ¤Ç¤­¤Þ¤¹¡£


¤µ¤Æ¡¢¤Á¤ç¤Ã¤ÈŤ¯¤Æ¤­¤Ä¤¤¤Ç¤¹¤¬¼¡¤Ç¤¹¡£¼¡¤Ï­£¤ÎÉôʬ¤Ç¤¹¤Í¡£
¤³¤³¤Ç¤Ï¡¢¼ÂºÝ¤Î¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ÎºÂɸ¤òÀßÄꤷ¤Æ¤¤¤Þ¤¹¡£Àè¤Û¤É¤Î¤Ï¤ß¤À¤·Ëɻ߽èÍý¤Î»ÅÁȤߤ¬Íý²ò¤Ç¤­¤Æ¤¤¤ì¤Ð¡¢¹Í¤¨Êý¤ÏƱ¤¸¤Ê¤Î¤Ç¡¢¤Ê¤ó¤È¤Ê¤¯¤ï¤«¤ë¤È»×¤¤¤Þ¤¹¡£

¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ÎLeft¡¦Top¤¬( 0 , 0 )¤À¤È²¾Äꤹ¤ë¤È¡¢¤½¤ÎÃæ¿´¤ÎºÂɸ¤È¤Ê¤ë X ¡¦ Y ¤Ï¡¢( 9 , 9 )¤È¤Ê¤ê¤Þ¤¹¡£¤â¤·Left¡¦Top¤¬( 10 , 10 )¤À¤È¤¹¤ì¤Ð¡¢ X ¡¦ Y ¤Ï¡¢( 19 , 19 )¤Ç¤¹¤Í¡£

ÊÑ¿ôPlayer_Data¤ÎÍ×ÁÇ X ¤È¡¢Í×ÁÇ Y ¤«¤é¡¢9¤ò°ú¤­»»¤·¤¿·ë²Ì¤òµá¤á¤Æ¡¢¤½¤ì¤ò¥³¥ó¥È¥í¡¼¥ë¤ÎLeft¤È¡¢Top¤ËÀßÄꤹ¤ì¤Ð¤¤¤¤¤ï¤±¤Ç¤¹¡£With¥¹¥Æ¡¼¥È¥á¥ó¥È¤ò»È¤Ã¤Æ¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Ë¤¢¤ëPlayer¤È¤¤¤¦Ì¾Á°¤Î¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ËÂФ·¤Æ¡¢·×»»¤·¤¿·ë²Ì¤òÀßÄꤷ¤Þ¤¹¡£

¤³¤Î­£¤ÎÉôʬ¤òÀßÄꤷ¤¿»þÅÀ¤Ç¡¢½é¤á¤Æ¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Î¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Î°ÌÃÖ¤¬·èÄꤷ¤Þ¤¹¡£º£¤Þ¤Ç¡¢X ¤ä Y ¤ò»È¤Ã¤Æ·×»»¤·¤Æ¤­¤¿·ë²Ì¤¬¡¢¤³¤³¤Ç½é¤á¤Æ¼Â¤ò·ë¤Ö¤Î¤Ç¤¹¡£

ºÂɸ¤À¤Î¤Ê¤ó¤À¤Î¤È¡¢¾¯¤·Æñ¤·¤¤¹Í¤¨Êý¤¬½Ð¤Æ¤­¤Þ¤·¤¿¤¬¡¢¥³¡¼¥É¤ò¤è¤¯¸«¤Æ¡¢¤¸¤Ã¤¯¤ê¹Í¤¨¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£¤É¤¦¤·¤Æ¤â¤ï¤«¤ê¤Å¤é¤¤¾ì¹ç¤Ï¡¢»æ¤Ë»Í³Ñ·Á¤ò½ñ¤¤¤Æ¹Í¤¨¤Æ¤ß¤ë¤È¡¢Íý²ò¤·¤ä¤¹¤¤¤È»×¤¤¤Þ¤¹¡£¼ÂºÝ»ä¤ÏƬ¤ÎÃæ¤Ç¡¢»Í³Ñ·Á¤ò¥¤¥á¡¼¥¸¤·¤Ê¤¬¤é¥³¡¼¥É¤ò½ñ¤¤¤Æ¤¤¤ë¤³¤È¤¬Â¿¤¤¤Ç¤¹¡£


Êä­¥³¥é¥à¡§Ifʸ¤Îµ­½ÒË¡

Àè¤Û¤É¤Î¥³¡¼¥ÉÆâ¤Ç¡¢½é¤á¤ÆÆÃ¼ì¤ÊIfʸ¤Îµ­½Ò¤¬½Ð¤Æ¤­¤Þ¤·¤¿¡£
ÉáÄÌ¡¢Ifʸ¤Ï¼¡¤Î¤è¤¦¤Ëµ­½Ò¤·¤Þ¤¹¡£

If ¾ò·ï Then
    ¾ò·ï¤¬¿¿¤Î¾ì¹ç¤Î½èÍý¡Á
End If

¡ØIf¡Ù¤«¤é»Ï¤Þ¤ê¡Ø¾ò·ï¡Ù¤½¤·¤Æ¡ØThen¡Ù¤Èµ­½Ò¤·¡¢¾ò·ï¤¬¿¿¤À¤Ã¤¿¾ì¹ç¤Ë¤ÏÃæ¤Ëµ­½Ò¤µ¤ì¤¿½èÍý¤¬¹Ô¤ï¤ì¤Þ¤¹¡£¤½¤ì¤«¤éºÇ¸å¤Ï¡ØEnd If¡Ù¤Ç½ª¤ï¤ë¤Î¤¬¥ë¡¼¥ë¤Ç¤·¤¿¤Í¡£
¤·¤«¤·¡¢º£²óÅо줷¤¿Ifʸ¤Ï¼¡¤Î¤è¤¦¤Ëµ­½Ò¤µ¤ì¤Æ¤¤¤Þ¤¹¡£

If ¾ò·ï Then ¾ò·ï¤¬¿¿¤Î¾ì¹ç¤Î½èÍý¡Á

º£¤Þ¤Ç¤ÎIfʸ¤È¤Ï°ã¤¤¡¢Á´¤Æ¤Î¥³¡¼¥É¤¬£±¹Ô¤Çµ­½Ò¤µ¤ì¤Æ¤¤¤ë¾å¡¢¤É¤³¤Ë¤â¡ØEnd If¡Ù¤¬¸«Åö¤¿¤ê¤Þ¤»¤ó¤Í¡£
¼Â¤Ï¡¢¤³¤ì¤Ïʸˡ¾åǧ¤á¤é¤ì¤Æ¤¤¤ë¡ØIfʸ¤Î¤â¤¦¤Ò¤È¤Ä¤Î½ñ¤­Êý¡Ù¤Ê¤ó¤Ç¤¹¤Í¡£´Êñ¤Ê¾ò·ïȽÃǤ䡢¿¿¤Î¾ì¹ç¤Ë¹Ô¤¦¤Ù¤­½èÍý¤¬Ã±½ã¤Ê¾ì¹ç¤Ê¤É¤Ï¡¢¤³¤Î¤è¤¦¤Êµ­½Ò¤Î»ÅÊý¤ò¤¹¤ë¤³¤È¤Ç¡¢¥³¡¼¥Ç¥£¥ó¥°¤Ë¤«¤«¤ë¼ê´Ö¤ò·Ú¸º¤Ç¤­¤Þ¤¹¡£¾õ¶·¤Ë±þ¤¸¤Æ¡¢»È¤Ã¤Æ¤ß¤ë¤Î¤â¤¤¤¤¤Ç¤·¤ç¤¦¡£¤¿¤À¤·¡¢»ä¤Î»î¤·¤¿´¶³Ð¤Ç¤Ï¡¢¤³¤ì¤Ë¤è¤ë½èÍý¤Î¹â®²½¤Ê¤É¤ÏÆÃ¤Ë¤Ê¤¤¤è¤¦¤Êµ¤¤¬¤·¤Þ¤¹¡£¤ï¤«¤ê¤ä¤¹¤µ¤òÂè°ì¤Ë¿ø¤¨¤Æ¡¢¼«Ê¬¤¬Íý²ò¤·¤ä¤¹¤¤¥³¡¼¥É¤ò½ñ¤­¤Þ¤·¤ç¤¦¡£



¢£¤³¤³¤Þ¤Ç¤òÁí¤Þ¤È¤á

¤µ¤Æ¡¢ºÂɸ·Ï¤Î·×»»¤Ï¾¯¤·Æñ¤·¤¤½èÍý¤Ç¤·¤¿¤¬¡¢¤É¤¦¤Ç¤·¤ç¤¦¡¢¤Ä¤¤¤Æ¤³¤ì¤Æ¤¤¤ë¤Ç¤·¤ç¤¦¤«¡£¤³¤³¤Ç´ðËÜŪ¤ÊºÂɸ·×»»¤Î¹Í¤¨Êý¤¬Íý²ò¤Ç¤­¤Æ¤·¤Þ¤¨¤Ð¡¢¤³¤ì¤«¤éÀè¡¢¤É¤Î¤è¤¦¤Ê¥­¥ã¥é¥¯¥¿¡¼¤Ê¤É¤Ç¤âƱ¤¸»ÅÁȤߤǽèÍý¤·¤Æ¤¤¤¯¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£
¾Ç¤ëɬÍפϤʤ¤¤Î¤Ç¡¢¤·¤Ã¤«¤ê½¬ÆÀ¤·¤Æ¤¯¤À¤µ¤¤¤Í¡£

¤µ¤Æ¡¢¤³¤³¤Þ¤Ç½ÐÍ褿¤éºÇ¸å¤Î»Å¾å¤²¤ò¤·¤Þ¤·¤ç¤¦¡£

¤¢¤È¤ä¤é¤Ê¤¯¤Æ¤Ï¤¤¤±¤Ê¤¤¤³¤È¤Ï¡¢¡Ø¥²¡¼¥à¤Î½ªÎ»½èÍý¡Ù¤È¡¢¡Ø¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤«¤é¤Î¥³¡¼¥É¤Î¸Æ¤Ó½Ð¤·¡Ù¤Î£²¤Ä¤Ç¤¹¡£¤â¤¦¾¯¤·¤Ê¤Î¤Ç¤¬¤ó¤Ð¤ê¤Þ¤·¤ç¤¦¡£

°ÊÁ°¡¢¥á¥¤¥ó¥×¥í¥»¥¹¤ò²òÀ⤷¤¿¹ÖºÂ¤Ç¡¢¡ØMain¡Ù¤È¤¤¤¦Ì¾Á°¤Î¥×¥í¥·¡¼¥¸¥ã¤Î¿÷·Á¤òºÜ¤»¤Þ¤·¤¿¡£º£²ó¤Ï¤¹¤Ç¤Ë¥²¡¼¥à¤ÎºîÀ®¤ËÆþ¤Ã¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢¤³¤ÎMain¤È¤¤¤¦¥×¥í¥·¡¼¥¸¥ã¤âºîÀ®¤·¤Þ¤·¤ç¤¦¡£¤½¤ì¤¬¼¡¤Î¥³¡¼¥É¤Ç¤¹¡£

Sub Main() '¥á¥¤¥ó¥ë¡¼¥×¤È¤Ê¤ë¥×¥í¥·¡¼¥¸¥ã

    Dim Flg As Boolean
    Dim Stm As Long
    
    Call Init '­¡
    
    Flg = False
    
    Do Until Flg
        Stm = GetTickCount
        Call Player_Action '­¢
        DoEvents
        Do
            Call Sleep(1)
        Loop Until GetTickCount - Stm > 30
        If GetAsyncKeyState(Esc_Key) < 0 Then Flg = True '­£
    Loop
    
End Sub

¸½Ãʳ¬¤Ç¤Ï¡¢¤Þ¤À¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤·¤«ºîÀ®¤·¤Æ¤¤¤Þ¤»¤ó(Player_Action)¡£¤Ç¤¹¤Î¤Ç¥á¥¤¥ó¥ë¡¼¥×¤ÎÃæ¤Ç¸Æ¤Ó½Ð¤·¤Æ¤¤¤ë¥µ¥Ö¥×¥í¥·¡¼¥¸¥ã¤Ï¤Ò¤È¤Ä¤À¤±¤Ç¤¹¤Í¡£

¤³¤³¤Ç¤Î¥Ý¥¤¥ó¥È¤Ï£³¤Ä¡£

­¡¤ÎÉôʬ¤Ç¤Ï¡¢¤Þ¤º½é´ü²½½èÍýôÅö¤Î¡ØInit¡Ù¤ò¸Æ¤Ó½Ð¤·¤Æ¤¤¤Þ¤¹¡£¤³¤ì¤Ï¥á¥¤¥ó¥ë¡¼¥×¤¬»Ï¤Þ¤ëÁ°¤Ë¹Ô¤Ã¤Æ¤ª¤«¤Ê¤¤¤È°ÕÌ£¤¬¤¢¤ê¤Þ¤»¤ó¡£¥ë¡¼¥×¤ÎÃæ¤Ç¸Æ¤Ó½Ð¤·¤Æ¤·¤Þ¤¦¤È¡¢¥ë¡¼¥×¤¹¤ë¤¿¤Ó¤ËËè²ó½é´ü²½½èÍý¤¬¹Ô¤ï¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¤Î¤ÇÃí°Õ¤·¤Þ¤·¤ç¤¦¡£

­¢¤Ç¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤Î½èÍý¤ò¸Æ¤Ó½Ð¤·¤Æ¤¤¤Þ¤¹¡£Àè¤Û¤É°Üư½èÍý¤Ê¤É¤òµ­½Ò¤·¤¿¤¢¤ì¤Ç¤¹¤Í¡£

­£¤Ç¤Ï¡¢GetAsyncKeyState´Ø¿ô¤ò»È¤Ã¤Æ¤¤¤Þ¤¹¤Í¡£Á°²ó¤Î¹ÖºÂ¤ÇÀë¸À¤·¤¿Äê¿ôEsc_Key¤Ï¡¢¥¨¥¹¥±¡¼¥×¥­¡¼¤Î¥­¡¼¥³¡¼¥É¤òɽ¤·¤Æ¤¤¤Þ¤¹¡£
¤Ä¤Þ¤ê¡¢¤â¤·¥¨¥¹¥±¡¼¥×¥­¡¼¤¬²¡¤µ¤ì¤¿¤È¤­¤Ë¤Ï¡¢ÊÑ¿ôFlg¤ËTrue¤òÂåÆþ¤·¤Æ¡¢¥ë¡¼¥×¤¬½ªÎ»¤¹¤ë¤è¤¦¤Ë¤·¤Æ¤¤¤ë¤Î¤Ç¤¹¤Í¡£
¤³¤Î»ÅÁȤߤ¬¤¤¤ï¤æ¤ë¡Ø½ªÎ»½èÍý¡Ù¤Ç¤¹¡£¥²¡¼¥à¤Î¥á¥¤¥ó¥ë¡¼¥×¤«¤é¡¢¥­¡¼¤ÎÆþÎϤò¼õ¤±¼è¤Ã¤ÆÈ´¤±¤ë»ÅÁȤߤǤ¹¤Í¡£
¤³¤ì¤Ç¡¢¤È¤ê¤¢¤¨¤º¸½Ãʳ¬¤Î¥á¥¤¥ó¥×¥í¥»¥¹¤ÏÂç¾æÉפǤ¹¡£


¤½¤·¤Æ¼¡¤Ë¡Ø¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤«¤é¤Î¥³¡¼¥É¤Î¸Æ¤Ó½Ð¤·¡Ù¤Ç¤¹¡£¤³¤ì¤Ï¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¤ä¡¢¥¢¥Ë¥á¡¼¥·¥ç¥ó½èÍý¤Ê¤É¤Ç¡¢¤µ¤ó¤¶¤óͽ¹ÔÎý½¬¤·¤Æ¤­¤¿¤Î¤ÇÂç¾æÉפǤ·¤ç¤¦¡£
¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Ë¤¢¤ë¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤Î¡¢¥¯¥ê¥Ã¥¯¥¤¥Ù¥ó¥È¤«¤é¡ØMain¡Ù¤ò¸Æ¤Ó½Ð¤»¤Ð¤¤¤¤¤Î¤Ç¤¹¡£

Private Sub Com_Start_Click()
    Com_Start.Enabled = False '­¡
    Call Main '­¢
    Unload UserForm1 '­£
End Sub

¤³¤ì¤¬¤½¤Î¥³¡¼¥É¤Ç¤¹¡£
¤Þ¤º­¡¤ÎÉôʬ¤Ç¡¢¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤ò¡Ø»ÈÍÑÉԲġ٤ξõÂÖ¤ËÀßÄꤷ¤Æ¤¤¤Þ¤¹¡£Enabled¥×¥í¥Ñ¥Æ¥£¤Ï¡¢¥³¥ó¥È¥í¡¼¥ë¤¬»ÈÍѤǤ­¤ë¤«¤Ç¤­¤Ê¤¤¤«¤òÄêµÁ¤¹¤ë¥×¥í¥Ñ¥Æ¥£¤Ç¤¹¡£¤³¤³¤Ë¡ØFalse¡Ù¤òÀßÄꤹ¤ë¤È¡¢¤½¤Î¥³¥ó¥È¥í¡¼¥ë¤Ïʸ»ú(Caption¤ÇÀßÄꤷ¤¿Ê¸»ú)¤¬³¥¿§¤ËÊѤï¤Ã¤Æ¤·¤Þ¤¤¡¢»ÈÍѤǤ­¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£
²¿Å٤⥯¥ê¥Ã¥¯¥¤¥Ù¥ó¥È¤¬È¯À¸¤·¤Æ¡¢Main¤¬Ê£¿ô²ó¸Æ¤Ó½Ð¤µ¤ì¤Æ¤·¤Þ¤ï¤Ê¤¤¤è¤¦¤Ë¤¹¤ë¤¿¤á¡¢£±²ó²¡¤µ¤ì¤¿»þÅÀ¤Ç¥³¥Þ¥ó¥É¥Ü¥¿¥ó¼«ÂΤò»ÈÍѤǤ­¤Ê¤¤¾õÂ֤ˤ·¤Æ¤·¤Þ¤¦¤ï¤±¤Ç¤¹¡£

¼¡¤Ë­¢¡£¤³¤ì¤Ï´Êñ¤Ç¤¹¤Í¡£Call¤Ç¥á¥¤¥ó¥×¥í¥»¥¹¤Ç¤¢¤ëMain¤ò¸Æ¤Ó½Ð¤·¤Æ¤¤¤Þ¤¹¡£

­£¤Ï¡¢½é¤á¤ÆÌܤˤ¹¤ë¥³¡¼¥É¤«¤â¤·¤ì¤Þ¤»¤ó¡£
¡ØUnload¡Ù¤È¤¤¤¦¤Î¤Ï¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤òÊĤ¸¤Ê¤µ¤¤¡¢¤È¤¤¤¦Ì¿Îá¤ò½Ð¤·¤Þ¤¹¡£È¾³Ñ¥¹¥Ú¡¼¥¹¤ò¶õ¤±¤Æ¡¢ÂоݤȤʤ륪¥Ö¥¸¥§¥¯¥È¤ò»ØÄꤹ¤ì¤Ð¤¤¤¤¤Î¤Ç¡¢º£²ó¤Ï¡ØUserForm1¡Ù¤È¤·¤Æ¤ª¤­¤Þ¤¹¡£

¤¨¡©¡¡¥Õ¥©¡¼¥à¤òÊĤ¸¤Á¤ã¤Ã¤Æ¤¤¤¤¤Î¡©¡¡¤È»×¤¦¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡¢¤³¤ì¤¬¼Â¤ÏÂç¾æÉפʤó¤Ç¤¹¡£
­¢¤ÎÉôʬ¤Ç¡ØMain¡Ù¤¬¸Æ¤Ó½Ð¤µ¤ì¤Æ¤¤¤Þ¤¹¤è¤Í¡£¥×¥í¥·¡¼¥¸¥ã¤ÎÃæ¤ÇÊÌ¤Î¥×¥í¥·¡¼¥¸¥ã¤ò¸Æ¤Ó½Ð¤·¤¿¾ì¹ç¤Ï¡¢¤½¤Î½èÍý¤¬½ª¤ï¤ë¤Þ¤Ç¡¢­£¤ÎÉôʬ¤Ë½èÍý¤¬¿Ê¤à¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¡£
Main¤ÎÃæ¤Ç½ªÎ»½èÍý¤¬¹Ô¤ï¤ì¤Æ¡¢´°Á´¤ËMain¤¬½ªÎ»¤·¤¿»þÅÀ¤Ç­£¤ÎÉôʬ¤Ë¤ä¤Ã¤È½èÍý¤¬²ó¤Ã¤Æ¤­¤Þ¤¹¡£¤³¤¦¤·¤Æ¤ª¤±¤Ð¡¢Àè¤Û¤É¤Î¥¨¥¹¥±¡¼¥×¥­¡¼¤Ç¤Î½ªÎ»½èÍý¤¬¹Ô¤ï¤ì¤ë¤È¡¢¤½¤Î¤Þ¤Þ¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤¬ÊĤ¸¤ë¤È¤³¤í¤Þ¤Ç¡¢Æ±»þ¤Ë¹Ô¤ï¤ì¤ë¤è¤¦¤Ë¤Ê¤ë¤Î¤Ç¤¹¤Í¡£

¤¢¤È¤Ï¡¢°Üư½èÍý¤Î¤È¤³¤í¤Ç¹Ô¤Ã¤¿¤Î¤ÈƱÍͤˡ¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Î¥¯¥¨¥ê¥¯¥í¡¼¥¹¥¤¥Ù¥ó¥È¤Ç¡¢Ç°¤Î¤¿¤áÁ´¤Æ¤Î¥³¡¼¥É¤¬»ß¤Þ¤ë¤è¤¦¤Ë¤·¤Þ¤¹¡£¤³¤¦¤·¤Æ¤ª¤±¤Ð¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤¬ÊĤ¸¤é¤ì¤ë¤ÈƱ»þ¤Ë¡¢³Î¼Â¤ËÁ´¤Æ¤Î¥×¥í¥·¡¼¥¸¥ã¤Î½èÍý¤¬»ß¤Þ¤ê¤Þ¤¹¡£°ÂÁ´¤Ç¤¹¤Í¡£

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



¢£¤³¤³¤Þ¤Ç¤ÎÁ´¥³¡¼¥É

¤«¤Ê¤êŤ¤Æ»¤Î¤ê¤Ç¤·¤¿¡£¥×¥é¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤òºîÀ®¤·¤¿¤¤¤À¤±¤Ê¤Î¤Ë¡¢¤Ê¤ó¤Ç¤³¤ó¤Ê¤Ë¤ä¤ë¤³¤È¤¬¤Æ¤ó¤³À¹¤ê¤Ê¤ó¤Ç¤·¤ç¤¦¤«¡Ä¡Ä¡£¤·¤«¤·¡¢¤³¤ì¤Ç´ðÈפ¬¤Û¤Ü´°À®¤·¤¿¤È¸À¤Ã¤Æ¤¤¤¤¤Ç¤·¤ç¤¦¡£¤Ä¤Þ¤ê¡¢¤³¤³¤«¤éÀè¤Ï¥×¥é¥â¥Ç¥ë¤Î¥Ñ¡¼¥Ä¤ò·Ñ¤®Â­¤¹¤¬¤´¤È¤¯¡¢¥×¥í¥·¡¼¥¸¥ã¤òÄɲ䷤Ƥ¤¤¯¤À¤±¤ÇÎɤ¤¤Î¤Ç¤¹¡£

Ť¯¸±¤·¤¤Æ»¤Î¤ê¤Ç¤Ï¤¢¤ê¤Þ¤·¤¿¤¬¡¢¤½¤ì¤À¤±¡¢²ÁÃͤΤ¢¤ë¤³¤È¤¬¤Ç¤­¤¿¤È¤¤¤¦¤³¤È¤Ç¤â¤¢¤ê¤Þ¤¹¡£ÅÓÃæ¡¢²¿ÅÙ¤«Æñ¤·¤¤Éôʬ¤¬¤¢¤Ã¤¿¤Ï¤º¤Ç¤¹¡£
Á´¤Æ¤ò°ìÅÙ¤ËÍý²ò¤Ç¤­¤Ê¤¯¤Æ¤â¡¢¤Ò¤È¤Ä¤Ò¤È¤Ä¤³¤Ê¤·¤Æ¤¤¤±¤Ð¡¢É¬¤º¤¦¤Þ¤¯¤¤¤¯¤Ï¤º¤Ç¤¹¡£¾Ç¤Ã¤Æ¤Ï¤¤¤±¤Þ¤»¤ó¡£

¤È¤ê¤¢¤¨¤º¸½Ãʳ¬¤Î¥³¡¼¥É¤òÁ´¤Æ°Ê²¼¤ËºÜ¤»¤Æ¤ª¤­¤Þ¤¹¡£
Á´ÂÎÁü¤È¡¢³Æ¥×¥í¥·¡¼¥¸¥ã¤ÎÌò³ä¤ä¹½Â¤¤ò¡¢¤·¤Ã¤«¤êÍý²ò¤·¤Æ¤¯¤À¤µ¤¤¡£É¬Íפ˱þ¤¸¤Æ¡¢²áµî¤ÎChapter¤ËÌá¤Ã¤ÆÉü½¬¤·¤Ê¤¬¤é¡¢´ðÈפò¤·¤Ã¤«¤ê¸Ç¤á¤Æ¤¯¤À¤µ¤¤¡£

¤³¤³¤Þ¤Ç¤ÎÁ´¥³¡¼¥É
'ɸ½à¥â¥¸¥å¡¼¥ëÀèÆ¬Éôʬ

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

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

'¢¥Äê¿ôÀë¸À
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 Player_Size As Single = 9
'¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤òɽ¤¹¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Î¼ÂºÝ¤ÎÉý(Â礭¤µ)
'¤¿¤À¤·¡¢¤¢¤È¤Ç»È¤¤¤ä¤¹¤¤¤è¤¦¤Ë£²Ê¬¤Î£±¤Ë¤·¤Æ¤ª¤¯



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

Sub Init()
    With Player_Data
        .X = 100 '²£°ÌÃÖ¤ò²èÌ̤ÎÃæ±û
        .Y = 180 '½Ä°ÌÃÖ¤ò²èÌ̤β¼¤¢¤¿¤ê
        .W = 0 '¤Þ¤À»ÈÍѤ·¤Ê¤¤¤Î¤Ç£°
        .H = 0 '¤Þ¤À»ÈÍѤ·¤Ê¤¤¤Î¤Ç£°
        .Lif = 1 '¸ºß¤·¤Æ¤¤¤ë¤Î¤Ç¥é¥¤¥Õ¤Ï£°¤è¤êÂ礭¤¤
        .Typ = 0 '¥×¥ì¥¤¥ä¡¼¤Ï¥¿¥¤¥×£°
        .Par = 0 '¤Þ¤À»ÈÍѤ·¤Ê¤¤¤Î¤Ç£°
    End With
End Sub


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

Sub Main()

    Dim Flg As Boolean
    Dim Stm As Long
    
    Call Init
    
    Flg = False
    
    Do Until Flg
        Stm = GetTickCount
        Call Player_Action
        DoEvents
        Do
            Call Sleep(1)
        Loop Until GetTickCount - Stm > 30
        If GetAsyncKeyState(Esc_Key) < 0 Then Flg = True
    Loop
    
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

    End With

    '¥Õ¥©¡¼¥à¾å¤Î¡ØPlayer¡Ù¤ò¼ÂºÝ¤Ë°Üư¤¹¤ë½èÍý¡¡
    With UserForm1.Player
        .Left = Player_Data.X - Player_Size
        .Top = Player_Data.Y - Player_Size
    End With

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


¤­¤Ã¤È¥Ö¥é¥¦¥¶¾å¤Ç¤³¤Î¥³¡¼¥É¤ò¸«¤ë¤È¡¢Èó¾ï¤ËŤ¯´¶¤¸¤ë¤È»×¤¤¤Þ¤¹¡£
¤Ç¤¹¤¬¡¢VBE¤ËޤêÉÕ¤±(¤â¤·¤¯¤Ï¼«ÎϤǽñ¤¯)¤·¤¿¸å¤Ëį¤á¤ë¤È¡¢¼ÂºÝ¤Ï¤½¤¦¤Ç¤â¤Ê¤¤¤Ç¤¹¡£Â¿Ê¬¡£

¥×¥í¥·¡¼¥¸¥ã¤¬¤½¤ì¤¾¤ìÀÚ¤êÎ¥¤µ¤ì¤Æ¤¤¤ë¤Î¤Ç¡¢»ë³ÐŪ¤Ë¤Ï¤«¤Ê¤ê¸«¤ä¤¹¤¤¤Ï¤º¤Ç¤¹¡£¡Ø¥³¡¼¥É¤ÎÉôÉʲ½¡Ù¤È¤¤¤¦¤³¤È¤¬¡¢¤É¤ì¤Û¤É¸ú²ÌŪ¤Ê¤Î¤«¤È¤¤¤¦¤³¤È¤¬¡¢¤ª¤Î¤º¤È¤ï¤«¤ë¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£

¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Î¤Û¤¦¤¬¤·¤Ã¤«¤ê½ÐÍè¤Æ¤¤¤ì¤Ð¡¢¤³¤Î¥³¡¼¥É¤òŬµ¹Å½¤êÉÕ¤±¤ë¤À¤±¤Ç¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤¬²èÌ̾å¤ò¼«Í³¤Ëư¤¯¥×¥í¥°¥é¥à¤¬´°À®¤·¤Þ¤¹¡£
¥×¥í¥°¥é¥à¤ò½ªÎ»¤·¤¿¤¤¤È¤­¤Ï¡¢¥Õ¥©¡¼¥à¾å¤Î¡ß¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤¹¤ë¤«¡¢¥¨¥¹¥±¡¼¥×¥­¡¼(Esc¥­¡¼)¤ò²¡¤»¤Ð¤¤¤¤¤Î¤Ç¤¹¤Í¡£¤¤¤º¤ì¤Î¾ì¹ç¤â¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Î¥¯¥¨¥ê¥¯¥í¡¼¥¹¥¤¥Ù¥ó¥È¤Ç¥³¡¼¥É¤¬»ß¤Þ¤ë¤Î¤ÇÌäÂꤢ¤ê¤Þ¤»¤ó¡£

¼«Í³µ¤¤Þ¤Þ¤Ë¡¢¥×¥ì¥¤¥ä¡¼¥­¥ã¥é¥¯¥¿¡¼¤òư¤«¤·¤ÆÍ·¤ó¤Ç¤ß¤Æ¤¯¤À¤µ¤¤¡£

¤¹¤ë¤È¡¢´ª¤Î¤¤¤¤¿Í¤Ê¤éµ¤¤¬¤Ä¤¯¤Ï¤º¤Ç¤¹¡£¤Á¤ç¤Ã¤È¤ª¤«¤·¤¤Éôʬ¤¬¤¢¤ë¤³¤È¤Ë¡Ä¡Ä¡£
¤½¤ÎÆæ¤Ï¼¡²ó²òÀ⡪¡¡º£²ó¤ÏŤ¹¤®¤Þ¤·¤¿¤Í¡£¤ªÈè¤ìÍͤǤ·¤¿¡£


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


¢£³Ê¸À

ºÂɸ·×»»¤ò½¬ÆÀ¤·¤è¤¦
¥Õ¥©¡¼¥à¤Î½àÈ÷¡¢³Æ¼ïÀë¸À¤â˺¤ì¤º¤Ë


¾Ç¤é¤º¤Ò¤È¤Ä¤Ò¤È¤Ä¤³¤Ê¤¹¡£¤³¤ì¤¬º£²ó¤â¥Ý¥¤¥ó¥È¤Ë¤Ê¤ê¤Þ¤¹¡£






Comment

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

¤³¤Î¥á¥¤¥ó¥ë¡¼¥×¤ÎÉôʬ¤Ê¤Î¤Ç¤¹¤¬¤³¤ÎEsc¤¬²¡¤µ¤ì¤¿¾ì¹ç¤Ë
¥á¥Ã¥»¡¼¥¸¥Ü¥Ã¥¯¥¹¡Ê£Ï£Ë¤È¥­¥ã¥ó¥»¥ë¡Ë
¤òɽ¼¨¤µ¤»,£Ï£Ë¤Ê¤é¤Ð¡¢¤½¤Î¤Þ¤Þ½ªÎ»
¥­¥ã¥ó¥»¥ë¤Ê¤é¡¢º£¤Þ¤Ç¥×¥ì¥¤¤·¤Æ¤¤¤¿
¾õÂÖ¤ËÌá¤ë¤³¤È¤Ï²Äǽ¤Ê¤Î¤Ç¤·¤ç¤¦¤«¡©
´Êñ¤Ë¤¤¤¤¤Þ¤¹¤È¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Î¥¯¥¨¥ê¥¯¥í¡¼¥¹¥¤¥Ù¥ó¥È
Ū¤Ê¤³¤È¤Ï¤Ç¤­¤ë¤Î¤Ç¤·¤ç¤¦¤«¡©

¹ÖºÂ¤Ë¤Ï´Ø·¸¤Ê¤¯¡¢ÂçÊѼºÎé¤Ê¼ÁÌä¤Ç¤¹¤¬¡¢
ÊÖ¿®¤ª´ê¤¤¤·¤Þ¤¹¡£¡Ê¤ªË»¤·¤¤¤Î¤Ë¿½¤·Ìõ
¤¢¤ê¤Þ¤»¤ó¡£¡Ë
  • ƿ̾´õ˾#4B33lOYw
  • URL
  • 2008.03.11(Tue)
  • Edit
¡äƿ̾´õ˾¤µ¤ó

¤Ï¤¸¤á¤Þ¤·¤Æ¡¢¤Ê¤Î¤«¤Ê¡£

·ëÏÀ¤«¤é¸À¤¦¤È¡¢²Äǽ¤Ç¤¹¡£
¤·¤«¤â¡¢¤è¤¯¹Í¤¨¤ì¤Ð¤ï¤«¤ë¤Ï¤º¤Ç¤¹¡£¤à¤º¤«¤·¤¯¤Ï¤¢¤ê¤Þ¤»¤ó¡£

¤Þ¤º¡¢Esc¥­¡¼¤Ç¥²¡¼¥à¤¬»ß¤Þ¤ë»ÅÁȤߡ¢¤³¤ì¤Ï¡¢

If GetAsyncKeyState(Esc_Key) < 0 Then Flg = True

¤³¤³¤ÎÉôʬ¤Ç¡¢ÊÑ¿ôFlg¤ËTrue¤òÂåÆþ¤¹¤ë¤³¤È¤Ç¡¢Do¡ÁLoopʸ¤Î½ªÎ»¾ò·ï¤¬Ëþ¤¿¤µ¤ì¤ë¤«¤é¡¢·ë²Ì¤È¤·¤Æ¥²¡¼¥à¤¬»ß¤Þ¤ë¤ï¤±¤Ç¤¹¤¬¡¢¤³¤³¤Þ¤Ç¤ÏÂç¾æÉפǤ¹¤Í¡©

ÂçÀڤʤ³¤È¤Ï¡¢Flg = True ¤Î¾ì¹ç¤Ë¥ë¡¼¥×¤¬»ß¤Þ¤ë¤È¤¤¤¦¤³¤È¤ò¡¢¥­¥Á¥ó¤ÈÍý²ò¤·¤Æ¤ª¤¯¤³¤È¤Ç¤¹¡£
True¤òÂåÆþ¤·¤Æ»ß¤Þ¤ë¤Ê¤é¡¢¥á¥Ã¥»¡¼¥¸¤Î·ë²Ì¤Ë¤è¤Ã¤Æ¡¢True¤òÆþ¤ì¤¿¤êÆþ¤ì¤Ê¤«¤Ã¤¿¤ê¤¹¤ì¤Ð¤¤¤¤¤ï¤±¤Ç¤¹¡£
Î㤨¤Ð¡¢¼¡¤Î¤è¤¦¤Ëµ­½Ò¤¹¤ì¤Ð¤¤¤¤¤Ç¤¹¤Í¡£

If MsgBox("½ªÎ»¡©", vbYesNo) = vbYes Then
    Flg = True
End If

¤³¤³¤Ç¾Ü¤·¤¯¤Ï²òÀ⤷¤Þ¤»¤ó¤¬¡¢¤³¤Î¤è¤¦¤Ë¤¹¤ì¤Ð¡¢¡Ø¤Ï¤¤¡Ù¤òÁªÂò¤·¤¿¤È¤­¤À¤±¡¢ÊÑ¿ôFlg¤ËTrue¤¬ÂåÆþ¤µ¤ì¤Þ¤¹¤Î¤Ç¡¢½ªÎ»¤¹¤ë¤«¤É¤¦¤«¤ò¥æ¡¼¥¶¡¼¤Ë¤æ¤À¤Í¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¤è¡£
  • ±Æ»Â#m.2.LkcQ
  • URL
  • 2008.03.11(Tue)
  • Edit
ÊÖ¿®¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡°¡°
¤ª¤«¤²¤µ¤Þ¤Ç¡¢½ªÎ»¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤·¤¿¡£
ºÇ½é¡¢»÷¤¿¤è¤¦¤Ê¥³¡¼¥É¤ò

If GetAsyncKeyState(Esc_Key) < 0 Then Flg = True ¤Î¸å¤Ë¡¢Îã¤Î¥³¡¼¥Éµ­½Ò¤·¤¿¤Î¤Ç¤¹¤¬¤³¤Î¾ì¹ç¤À¤È¡¢¤¤¤¤¤¨¤â²¡¤·¤Æ¤â¡¢Æ±¤¸¤¯½ªÎ»¤·¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£¡Ê¤ª¤½¤é¤¯Flg = True¤È¤¤¤¦¼°¤¬»Ä¤Ã¤Æ¤¤¤¿¤Î¤À¤È»×¤¤¤Þ¤¹¡£¡Ë
¤â¤Á¤í¤ó¤³¤Î½ê¤ÎDO¡¡LOOP¤Î¸å¤Ëµ­½Ò¤·¤Æ¤â
¤À¤á¤Ç¤·¤¿¡£
¤½¤·¤Æ¡¢ESC¥­¡¼ÆþÎÏȽÄê¤Î¼°¤Î½ê¤Ë¡¢¥á¥Ã¥»¡¼¥¸
¤Î¥Ü¥Ã¥¯¥¹¤Î¼°¤òÆþ¤ì¤¿¤é¡¢Ìµ»ö½ªÎ»¡£¥­¥ã¥ó¥»¥ë¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤·¤¿¡£

¤ªË»¤·¤¤¤Î¤ËÂçÊÑ¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£
¤½¤ì¤È¥µ¥Ý¡¼¥È·Ç¼¨ÈĤÎÊý¤Ë½ñ¤­¹þ¤ó¤ÀÊý¤¬Îɤ«¤Ã¤¿¤Ç¤·¤ç¤¦¤«¡©
  • ƿ̾´õ˾#4B33lOYw
  • URL
  • 2008.03.12(Wed)
  • Edit
¡äƿ̾´õ˾¤µ¤ó

¤¦¤Þ¤¯¤¤¤Ã¤Æ¡¢¤è¤«¤Ã¤¿¤Ç¤¹¤Í¡£

¡ä¥µ¥Ý¡¼¥È·Ç¼¨ÈĤÎÊý¤Ë½ñ¤­¹þ¤ó¤ÀÊý¤¬Îɤ«¤Ã¤¿¤Ç¤·¤ç¤¦¤«¡©
¤¢¤Ã¤Á¤Ï³«Àߤ·¤¿¤Ð¤«¤ê¤Ç¡¢¤Þ¤À¤Û¤È¤ó¤É½ñ¤­¹þ¤ß¤¬¤Ê¤¤¤Ç¤¹¤«¤é¡¢¤½¤¦¤¤¤Ã¤¿°ÕÌ£¤Ç¤Ï¸þ¤³¤¦¤Ç¤â¤è¤«¤Ã¤¿¤«¤â¡£¤Ç¤â¼ÂºÝ¤Ï¤É¤Ã¤Á¤Ç¤â¤¤¤¤¤Ç¤¹¡£
¤ä¤ê¤ä¤¹¤¤¤è¤¦¤Ë¤·¤Æ¤¤¤¿¤À¤±¤ì¤ÐÂç¾æÉפǤ¹¡£

¤Þ¤¿²¿¤«¤¢¤Ã¤¿¤é¤ªµ¤·Ú¤Ë¤ª¿Ò¤Í¤¯¤À¤µ¤¤¡£
  • ±Æ»Â#m.2.LkcQ
  • URL
  • 2008.03.12(Wed)
  • Edit
¥¨¥¯¥»¥ëVBA¤Ç¸¡º÷Áë¤òºî¤ë¤È¤¤¤¦HP¤ò½ñ¤¤¤Æ¤ª¤ê¤Þ¤¹kato¤Ç¤¹¡£¥³¥á¥ó¥È¤ò¤¤¤¿¤À¤­¤Þ¤·¤ÆËÜÅö¤Ë¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£Áá®ˬÌ䤵¤»¤Æ¤¤¤¿¤À¤­¤Þ¤·¤¿¡£ÌÌÇò¤½¤¦¤Ê¥³¥ó¥Æ¥ó¥Ä¤¬¤¿¤¯¤µ¤ó¤¢¤Ã¤Æ¤É¤³¤«¤éÆÉ¤ó¤Ç¤¤¤¤¤Î¤«¤ï¤«¤é¤Ê¤¤¤¯¤é¤¤¤Ç¤¹¡£¡Ê¾Ð¡Ë¥Ö¥Ã¥¯¥Þ¡¼¥¯¤µ¤»¤Æ¤¤¤¿¤À¤­¡¢¾¯¤·¤º¤ÄÊÙ¶¯¤µ¤»¤Æ¤¯¤À¤µ¤¤¡£ÁÇÀ²¤é¤·¤¤¥µ¥¤¥È¤Ç¤¹¡£
  • kato kazushi#tuhYp8FY
  • URL
  • 2008.05.18(Sun)
  • Edit
¡äkato kazushi¤µ¤ó

¤³¤Á¤é¤³¤½¤´Íèˬ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
¥³¥á¥ó¥È¤Þ¤Ç夤¤Æ¡¢´ò¤·¤¤¸Â¤ê¤Ç¤¹¡£

ÆâÍÆ¤Ï¤³¤ì¤«¤é¤â¤¬¤ó¤Ð¤Ã¤Æ½¼¼Â¤µ¤»¤Æ¤¤¤­¤Þ¤¹¡£Æ±¤¸VBA¤ò°·¤¦¤â¤Î¤È¤·¤Æ¡¢Ëö±Ê¤¯¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¤Í¡£
  • ±Æ»Â#m.2.LkcQ
  • URL
  • 2008.05.18(Sun)
  • Edit

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



¥×¥í¥°¥é¥ß¥ó¥°¤ä 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 ´ØÏ¢½ñÀÒ