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

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

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



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


£Ã£è£á£ð£ô£å£ò.£²£° [ ¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¡§£µ °ú¿ô]

¢£°ú¿ô

¤µ¤Æ¡¢Á°²ó¤Þ¤Ç¤Ç¡¢¼ê½ç£±¡Á£µ¤Þ¤Ç¤ò²òÀ⤷¤Þ¤·¤¿¡£º£²ó¤«¤é²òÀ⤹¤ë¤Î¤Ï¼ê½ç¤Î£¶ÈÖÌܡأ¶¡§ÁÐÊý¤ÎÌò¤ò¸µ¤Ë¾¡Éé¤òȽÄê¡Ù¤Ç¤¹¡£
¼Â¤Ï¤³¤Î¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¤ÎºÇÂç¤ÎÆñ´Ø¤Ç¤â¤¢¤ê¡¢½èÍý¤ÎÃæ¿´Åª¤ÊÌò³ä¤ò²Ì¤¿¤¹Éôʬ¤¬¡¢¤³¤Î¼ê½ç£¶¤Î¤È¤³¤í¤Ç¤¹¡£µ¤¹ç¤òÆþ¤ì¤Æ¼è¤ê³Ý¤«¤ê¤Þ¤·¤ç¤¦¡£

º£²ó¤Ï·ÇÂê¤Î¤È¤ª¤ê¡¢¡Ø°ú¿ô¡Ù¤Ë¤Ä¤¤¤Æ²òÀ⤷¤Þ¤¹¡£¤³¤Î°ú¿ô¤È¤¤¤¦³µÇ°¤â¡¢¥×¥í¥°¥é¥ß¥ó¥°¤Ë·ç¤«¤»¤Ê¤¤³µÇ°¤Ç¤¹¡£³Ð¤¨¤ì¤Ð³Î¼Â¤Ë¼ÂÎÏ¥¢¥Ã¥×¤Ç¤¹¤Î¤Ç¡¢´èÄ¥¤Ã¤Æ¤¯¤À¤µ¤¤¤Í¡£

°ú¿ô¤È¤¤¤¦¤Î¤Ï¡¢¡Ø¥Ç¡¼¥¿¤Î¶¶ÅϤ·Ìò¡Ù¤È¹Í¤¨¤ë¤È°ìÈ֤狼¤ê¤ä¤¹¤¤¤Î¤Ç¤Ï¤Ê¤¤¤«¤È»×¤¤¤Þ¤¹¡£¥×¥í¥·¡¼¥¸¥ã¤È¥×¥í¥·¡¼¥¸¥ã¤Î´Ö¤Ç¡¢¥Ç¡¼¥¿¤ò¤ä¤ê¼è¤ê¤¹¤ë¤È¤­¤Ë¤Ï¡¢Èó¾ï¤Ë½ÅÍפÊÌò³ä¤ò²Ì¤¿¤·¤Þ¤¹¡£

Î㤨ÏäȤ·¤Æ¡¢¤³¤ó¤ÊÏäò¤·¤Æ¤ß¤Þ¤·¤ç¤¦¡£

¤¢¤ë¤È¤³¤í¤Ë¡¢¤ª»È¤¤¥í¥Ü¥Ã¥È¤¬¤¤¤Þ¤¹¡£Èà¤Ï¡¢°ÍÍꤵ¤ì¤¿¤È¤ª¤ê¤Ë¡¢°ìÉʻĤ餺´°àú¤Ë¤ª»È¤¤¤·¤Æ¼ê¤ËÆþ¤ì¤Æ¤­¤Æ¤¯¤ì¤Þ¤¹¡£¤Ê¤ó¤È¤â¤¹¤´¤¤¥í¥Ü¥Ã¥È¤Ç¤¹¡£
¤Ç¤â¡¢Èà¤Ï¼«Ê¬¤Ç¹Í¤¨¤Æ¤ª»È¤¤¤·¤Æ¤¯¤ë¤³¤È¤Ï¤Ç¤­¤Þ¤»¤ó¡£¤¢¤¯¤Þ¤Ç¤â¡¢¤ª»È¤¤¤·¤Æ¤¯¤ë¤Ù¤­¾¦ÉʤȤ¤¤¦¥Ç¡¼¥¿¤ò¤â¤é¤Ã¤Æ¡¢½é¤á¤Æµ¡Ç½¤¹¤ë¥í¥Ü¥Ã¥È¤Ê¤Î¤Ç¤¹¡£Èà¤Ïº£Æü¤â¡¢¤´¼ç¿Í¤Î̵Íý¤ÊÃíʸ¤Ë±þ¤¨¤ë¤Ù¤¯¡¢¥é¥¤¥È¤Ô¤«¤Ô¤«³¹¤òÊ⤭²ó¤ê¤Þ¤¹¡£


¤µ¤Æ¡¢¤³¤Î¡Ø¤ª»È¤¤¥í¥Ü¥Ã¥È¡Ù¤ò¡¢¡Ø¥×¥í¥·¡¼¥¸¥ã¡Ù¤ËÃÖ¤­´¹¤¨¤Æ¤ß¤ë¤È¤É¤¦¤Ç¤·¤ç¤¦¤«¡£

¤¢¤ë¤È¤³¤í¤Ë¡Ø¤¸¤ã¤ó¤±¤ó¡Ù¤È¤¤¤¦¥×¥í¥·¡¼¥¸¥ã¤¬¤¢¤ê¤Þ¤¹¡£¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤Ï¡¢¤¸¤ã¤ó¤±¤ó¤ÎÌò¤ò¸µ¤Ë¡¢¾¡Éé¤òȽÄꤹ¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£¤·¤«¤â¡¢¼«Ê¬¤Ç¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤ò¥é¥ó¥À¥à¤Ë·è¤á¤ëµ¡Ç½¤ò»ý¤Ã¤Æ¤¤¤Þ¤¹¡£
¤Ç¤â¡¢¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤Ï¡¢¥×¥ì¥¤¥ä¡¼¤ÎÌò¤ò¼«Ê¬¤Ç¹Í¤¨¤Æ·è¤á¤ë¤³¤È¤Ï¤Ç¤­¤Þ¤»¤ó¡£¤¢¤¯¤Þ¤Ç¤â¡¢¥×¥ì¥¤¥ä¡¼¤¬·è¤á¤¿Ìò¤È¤¤¤¦¥Ç¡¼¥¿¤ò¤â¤é¤Ã¤Æ¡¢½é¤á¤Æµ¡Ç½¤¹¤ë¥×¥í¥·¡¼¥¸¥ã¤Ê¤Î¤Ç¤¹¡£º£Æü¤â¤¸¤ã¤ó¤±¤ó¤È¤¤¤¦¥×¥í¥·¡¼¥¸¥ã¤Ï¡¢Ã¸¡¹¤È¾¡Éé¤òȽÄꤷ³¤±¤Þ¤¹¡£


¾å¤ÎÎã¤Ç¸À¤¦¤È¤³¤í¤Î¡¢¡Ø¥Ç¡¼¥¿¡Ù¤³¤½¤¬¡Ø°ú¿ô¡Ù¤Ê¤Î¤Ç¤¹¡£

º£²ó¤È¼¡²ó¤Î£²²ó¤Ëʬ¤±¤Æ¡¢¼ÂºÝ¤ËÌò¤òȽÄꤹ¤ëÉôʬ¤Î¥×¥í¥°¥é¥ß¥ó¥°¤ò²òÀ⤷¤Þ¤¹¤¬¡¢¤½¤ì¤Ï¤¢¤¯¤Þ¤Ç¤â¡Ø¥×¥ì¥¤¥ä¡¼¤Î·è¤á¤¿Ìò¡Ù¤È¤¤¤¦¥Ç¡¼¥¿¤¬¤¢¤Ã¤Æ¤³¤½¡¢°ÕÌ£¤ò»ý¤Ä¥×¥í¥°¥é¥à¤Ë¾¤Ê¤ê¤Þ¤»¤ó¡£¤Ç¤¹¤«¤é¡¢¤Þ¤º¤Ï°ú¿ô¤È¤¤¤¦³µÇ°¤ò¤·¤Ã¤«¤ê¤ÈÍý²ò¤·¡¢¥×¥í¥·¡¼¥¸¥ã¤«¤é¥×¥í¥·¡¼¥¸¥ã¤Ø¡¢¥Ç¡¼¥¿¤òÅϤ¹¤ä¤êÊý¤ò³Ð¤¨¤Þ¤·¤ç¤¦¡£


¢£°ú¿ô¤Î»È¤¤Êý

°ú¿ô¤ò»È¤¦¤¿¤á¤Ë¤Ï¡¢£²¤Ä¤Î¥¹¥Æ¥Ã¥×¤¬É¬ÍפǤ¹¡£

£±¡§°ú¿ô¤ò¼õ¤±¼è¤ë¥×¥í¥·¡¼¥¸¥ã¤Î½àÈ÷
£²¡§ÌÜŪ¤Î¾ì½ê¤Ç°ú¿ô¤ò»ØÄꤷ¤Æ¥×¥í¥·¡¼¥¸¥ã¤ò¸Æ¤Ó½Ð¤¹

¤³¤Î£²¤Ä¤Ç¤¹¡£

Á°²ó¤Î¹ÖºÂ¤Ç¡¢£²ÈÖÌܤÎÉôʬ¡¢¤Ä¤Þ¤ê¾¤Î¥×¥í¥·¡¼¥¸¥ã¤ò¸Æ¤Ó½Ð¤¹ÊýË¡¤Ï²òÀ⤷¤Þ¤·¤¿¡£¤½¤ì¤Ë¤ÏCall¤È¤¤¤¦¥­¡¼¥ï¡¼¥É¤ò»È¤¨¤Ð¤è¤«¤Ã¤¿¤Î¤Ç¤·¤¿¤Í¡£
¾åµ­¤Î£±ÈÖÌܤÎÉôʬ¤Ç¿¨¤ì¤Æ¤¤¤ë¤è¤¦¤Ë¡¢¤Þ¤º¤ÏCall¤Ç¸Æ¤Ó½Ð¤µ¤ì¤ë¥×¥í¥·¡¼¥¸¥ã¤Î½àÈ÷¤ò¤·¤Ê¤¯¤Æ¤Ï¤¤¤±¤Þ¤»¤ó¡£

¤½¤ì¤Ç¤Ï¡¢¤Þ¤ºº£¤Þ¤Ç¤Î²òÀâ¤Ç½ÐÍè¾å¤¬¤Ã¤Æ¤¤¤ë¡¢¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¤Î¥³¡¼¥É¤ò¸«¤Æ¤ß¤Þ¤·¤ç¤¦¡£

Sub Janken()
    Dim CPU As Long
    Randomize
    CPU = Int(Rnd * 3) + 1
    MsgBox "¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤Ï" & CPU & "¤Ç¤¹"
End Sub


¸½»þÅÀ¤Ç¤Ï¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤ò¥é¥ó¥À¥à¤Ë·è¤á¤Æ¡¢¤½¤ì¤ò¥á¥Ã¥»¡¼¥¸¤È¤·¤ÆÉ½¼¨¤¹¤ë¤È¤¤¤¦µ¡Ç½¤À¤±¤¬¡¢¼ÂÁõ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
¤³¤Î¥µ¥Ö¥×¥í¥·¡¼¥¸¥ã¡ØJanken¡Ù¤ò¡¢°ú¿ô¤ò¼è¤ë¤è¤¦¤ËÊѹ¹¤¹¤ë¤È¡¢¼¡¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

Sub Janken(PLAYER As Integer)
    Dim CPU As Long
    Randomize
    CPU = Int(Rnd * 3) + 1
    MsgBox "¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤Ï" & CPU & "¤Ç¤¹"
End Sub


¤É¤³¤¬ÊѤï¤Ã¤¿¤«¤ï¤«¤ê¤Þ¤¹¤«¡©
½èÍý¤ò¹Ô¤¦¥³¡¼¥É¤ÎÉôʬ¤Ë¤ÏÁ´¤¯Êѹ¹¤¬¤¢¤ê¤Þ¤»¤ó¤¬¡¢¥×¥í¥·¡¼¥¸¥ã¤Î̾Á°¤òÀë¸À¤·¤Æ¤¤¤ë¡¢£±¹ÔÌܤÎÉôʬ¤¬ÊѤï¤Ã¤Æ¤¤¤ë¤Î¤¬¤ï¤«¤ë¤Ç¤·¤ç¤¦¤«¡©
Janken¤Î¸å¤í¤Ë¤¢¤ë³ç¸Ì¤ÎÃæ¤Ë¡¢¡ØPLAYER As Integer¡Ù¤È¤¤¤¦µ­½Ò¤¬²Ã¤ï¤Ã¤Æ¤¤¤Þ¤¹¡£ÊÑ¿ô¤ÎÀë¸À¤ò¹Ô¤¦¤È¤­¤Î¤è¤¦¤Ë¡¢¡ØAs¡Ù¤Ë³¤±¤Æ·¿¤òÀë¸À¤·¤Æ¤¤¤Þ¤¹¤Í¡£¤½¤¦¤Ç¤¹¡£¤³¤ì¤Ï¼Â¤ÏÊÑ¿ô¤ÎÀë¸À¤ÈÁ´¤¯Æ±¤¸ÍýÏÀ¤Ç¹Í¤¨¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£
¤³¤³¤ÇÀë¸À¤µ¤ì¤¿PLAYER¤È¤¤¤¦¤Î¤Ï¡¢¼ÂÂΤȤ·¤Æ¤ÏÊÑ¿ô¤Ç¤¹¡£¤½¤·¤ÆInteger·¿¤ÎÊÑ¿ô¤È¤·¤ÆÀë¸À¤µ¤ì¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢À°¿ô¤ò°·¤¦ÊÑ¿ô¤È¤·¤Æ¡¢¥µ¥Ö¥×¥í¥·¡¼¥¸¥ã¤ÎÃæ¤ÇÉáÄ̤˻Ȥ¦¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£

¤¿¤À¤·¡¢ÊÑ¿ôPLAYER¤Ï¡¢³ç¸Ì¤ÎÃæ¤ÇÀë¸À¤µ¤ì¤Æ¤¤¤ë¤Î¤Ç¡Ø°ú¿ô¡Ù¤Ç¤¹¡£
¤Ç¤¹¤«¤é¡¢¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤¬Æ°ºî¤¹¤ë¤È¤­¤Ë¤Ï¡¢´û¤Ë²¿¤é¤«¤Î¥Ç¡¼¥¿¤ò»ý¤Ã¤Æ¤¤¤Ê¤¯¤Æ¤Ï¤¤¤±¤Ê¤¤¤Î¤Ç¤¹¡£Àè¤ÎÎã¤Ç¸À¤¨¤Ð¡¢¤ª»È¤¤¤¹¤ë¾¦Éʤ¬¤ï¤«¤é¤Ê¤¤¤¦¤Á¤Ï¡¢¥í¥Ü¥Ã¥È¤¬¤ª»È¤¤¤Ë¤¤¤±¤Ê¤¤¤Î¤ÈƱ¤¸¤Ç¤¹¤Í¡£¤½¤³¤Ç¡¢¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤¬¸Æ¤Ó½Ð¤µ¤ì¤¿¤È¤­¤Ë¤Ï¡¢´û¤Ë¥×¥ì¥¤¥ä¡¼¤ÎÌò¤¬·è¤Þ¤Ã¤Æ¤¤¤Ê¤¯¤Æ¤Ï¤¤¤±¤Þ¤»¤ó¡£

¤½¤³¤Ç¥¹¥Æ¥Ã¥×¤Î£²ÈÖÌÜ¡£°ú¿ô¤ò»ØÄꤷ¤Æ¥×¥í¥·¡¼¥¸¥ã¤ò¸Æ¤Ó½Ð¤¹¡¢¤Î½ÐÈ֤Ǥ¹¡£

¸Æ¤Ó½Ð¤¹¤È¤­¤Ë°ú¿ô¤ò»ØÄꤹ¤ë¾ì¹ç¤Ï¡¢¤ä¤Ï¤ê³ç¸Ì¤ò»È¤¤¤Þ¤¹¡£Call¤ÇÊÑ¿ô¤ò¸Æ¤Ó½Ð¤¹ºÝ¤Ë¡¢°ú¿ô¤ò³ç¸Ì¤Ç°Ï¤ó¤Ç¤ä¤ì¤Ð¤¤¤¤¤À¤±¤Ç¤¹¡£Îã¤òµó¤²¤Æ¤ß¤Þ¤·¤ç¤¦¡£

¤Þ¤º¤Ï¡¢¸Æ¤Ó½Ð¤µ¤ì¤ë¥×¥í¥·¡¼¥¸¥ã¡¢¡ØJanken¡Ù¤Î¤Û¤¦¤ò¡¢°Ê²¼¤Î¤è¤¦¤Ë½¤Àµ¤·¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£

Sub Janken(PLAYER As Integer)
    Dim CPU As Long
    Randomize
    CPU = Int(Rnd * 3) + 1
    MsgBox "¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤Ï" & CPU & "¤Ç¤¹"
    MsgBox "¤Á¤Ê¤ß¤Ë¥×¥ì¥¤¥ä¡¼¤ÎÌò¤Ï" & PLAYER & "¤Ç¤¹"
End Sub


¼¡¤Ë¡¢¸Æ¤Ó½Ð¤¹Â¦¤Î½¤Àµ¤Ç¤¹¡£
¥Õ¥©¡¼¥à¥â¥¸¥å¡¼¥ë¤Î¡¢¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤Î¥¯¥ê¥Ã¥¯¥¤¥Ù¥ó¥È¥×¥í¥·¡¼¥¸¥ã¤Ç¡¢¥µ¥Ö¥×¥í¥·¡¼¥¸¥ãJanken¤ò¸Æ¤Ó½Ð¤·¤Æ¤¤¤Þ¤·¤¿¤Í¡£¤½¤Î¥³¡¼¥É¤Î¸Æ¤Ó½Ð¤·Éôʬ¤ò¼¡¤Î¤è¤¦¤Ë½¤Àµ¤·¤Þ¤·¤ç¤¦¡£

Private Sub Com_Kaisi_Click()
    Call Janken(1)
End Sub


Janken¤È¤¤¤¦¥×¥í¥·¡¼¥¸¥ã¤Ë¡¢°ú¿ô¤È¤·¤Æ¡Ø1¡Ù¤òÅϤ¹¤è¤¦¤Ë½¤Àµ¤·¤Þ¤·¤¿¡£¤³¤Î¥³¡¼¥É¤ò¼Â¹Ô¤¹¤ë¤È¡¢¥é¥ó¥À¥à¤Ë·è¤á¤é¤ì¤¿¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤¬É½¼¨¤µ¤ì¡¢¤½¤Î¸å¡¢¥×¥ì¥¤¥ä¡¼¤ÎÌò¤È¤·¤Æ¡¢¡Ø1¡Ù¤¬É½¼¨¤µ¤ì¤ë¤Ï¤º¤Ç¤¹¡£

100.gif

¤³¤¦¤Ê¤ì¤ÐÀ®¸ù¤Ç¤¹¡£
º£²ó¤Ï¡¢°ú¿ô¤È¤·¤Æ¡Ø1¡Ù¤È¤¤¤¦·è¤á¤é¤ì¤¿¿ô»ú¤òÅϤ·¤Æ¤¤¤ë¤À¤±¤Ç¤¹¤Î¤Ç¡¢¼Â¹Ô·ë²Ì¤ÏËè²óƱ¤¸¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¤·¤«¤·¡¢°ú¿ô¤È¤·¤Æ¥Ç¡¼¥¿¤òÅϤ·¤Æ¤¤¤ë¤³¤È¤¬¡¢¤³¤ì¤Ç¾ÚÌÀ¤Ç¤­¤Þ¤·¤¿¤Í¡£
¤¿¤á¤·¤Ë°ú¿ô¤È¤·¤ÆÍ¿¤¨¤ë¥Ç¡¼¥¿¤ò¿§¡¹ÊѤ¨¤Æ¼Â¹Ô¤·¤Æ¤ß¤ë¤È¡¢°ã¤¤¤¬¤ï¤«¤ë¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£

¤Á¤Ê¤ß¤Ë¡¢°ú¿ô¤ò¼õ¤±¼è¤ëÊÑ¿ôPLAYER¤Ï¡¢ÊÑ¿ô¤Î·¿¤¬Integer·¿¤Ç¤¹¤Î¤Ç¡¢À°¿ô°Ê³°¤Î¥Ç¡¼¥¿¤òÅϤ½¤¦¤È¤¹¤ë¤È¥¨¥é¡¼¤Ë¤Ê¤ê¤Þ¤¹¡£Ãí°Õ¤·¤Þ¤·¤ç¤¦¤Í¡£


¢£³Ê¸À

¥Ç¡¼¥¿¤ò¤ä¤ê¼è¤ê¤¹¤ë¤Ë¤Ï°ú¿ô¤ò³èÍÑ
°ú¿ô¤Ï£²¤Ä¤Î¥¹¥Æ¥Ã¥×¤Ç¼ÂÁõ¤¹¤ë


¤À¤ó¤À¤ó¥²¡¼¥à¤Î¹ü³Ê¤¬½ÐÍè¾å¤¬¤Ã¤Æ¤­¤Þ¤·¤¿¤Í¡£





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