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

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

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



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


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

¢£¥²¡¼¥à¼ê½ç¤Î³Îǧ

¤µ¤Æ¡¢Á°²ó¤Î¹ÖºÂ¤Ç¤Ï¡¢¼ê½ç£±¤ÎÉôʬ¡Ø£±¡§¥×¥ì¥¤¥ä¡¼¤¬¥²¡¼¥à¤òµ¯Æ°¡Ù¤Ë¤Ä¤¤¤Æ²òÀ⤷¤Þ¤·¤¿¡£

¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¤Î¥Õ¥í¡¼
    £±¡§¥×¥ì¥¤¥ä¡¼¤¬¥²¡¼¥à¤òµ¯Æ°
        ¢§
    £²¡§¥×¥ì¥¤¥ä¡¼¤¬½Ð¤¹Ìò¤ò·è¤á¤ë
        ¢§
    £³¡§¥Æ¥­¥¹¥È¥Ü¥Ã¥¯¥¹¤Ë¡¢Ìò¤Ë±þ¤¸¤¿¿ô»ú¤òÆþÎÏ
        ¢§
    £´¡§¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯(²¡¤¹)
        ¢§
    £µ¡§¥³¥ó¥Ô¥å¡¼¥¿¡¼Â¦¤ÎÌò¤ò¥×¥í¥°¥é¥à¤¬·è¤á¤ë
        ¢§
    £¶¡§ÁÐÊý¤ÎÌò¤ò¸µ¤Ë¾¡Éé¤òȽÄê
        ¢§
    £·¡§·ë²Ì¤òɽ¼¨
        ¢§
    £¸¡§½é´ü¾õÂÖ¤ËÌ᤹(¤Ä¤Þ¤ê¼ê½ç£²¤Î¾õÂ֤ˤ¹¤ë)


¼ê½ç¤Î£²¡Á£´¤Þ¤Ç¤Ï¡¢¥²¡¼¥à¤ò¥×¥ì¥¤¤·¤Æ¤¤¤ë¥×¥ì¥¤¥ä¡¼¤¬¹Ô¤¦Éôʬ¤Ç¤¢¤ê¡¢²æ¡¹¥×¥í¥°¥é¥Þ¡¼¤Ï´³¾Ä¤Ç¤­¤Ê¤¤Éôʬ¤Ç¤¹¤Í¡£º£²ó¤Ï£µÈÖÌܤμê½ç¡Ø£µ¡§¥³¥ó¥Ô¥å¡¼¥¿¡¼Â¦¤ÎÌò¤ò¥×¥í¥°¥é¥à¤¬·è¤á¤ë¡Ù¤Î¤È¤³¤í¤ò¸«¤Æ¤ß¤Þ¤·¤ç¤¦¡£

¥×¥ì¥¤¥ä¡¼¤¬½Ð¤¹¤¸¤ã¤ó¤±¤ó¤ÎÌò¤Ï¡¢£±¡Á£³¤Î¿ô»ú¤Î¤É¤ì¤«¤Ç¤¹¡£¤½¤·¤Æ¡¢¤½¤ì¤¾¤ì¤Î¿ô»ú¤ò¤¸¤ã¤ó¤±¤ó¤ÎÌò¤ËÊÑ´¹¤·¤Æ¹Í¤¨¤ë¤ó¤Ç¤·¤¿¤Í¡£¤È¤¤¤¦¤³¤È¤Ï¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤Î½Ð¤¹Ìò¤â¡¢¤ä¤Ï¤ê£±¡Á£³¤Î¿ô»ú¤Î¤É¤ì¤«¤Ç¤¢¤ë¤³¤È¤¬Ë¾¤Þ¤·¤¤¤Ç¤¹¤Í¡£

¤³¤Î¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤Ï¡¢Ëè²ó°ã¤Ã¤¿¤â¤Î¤Ç¤Ê¤¯¤Æ¤Ï¤Ê¤ê¤Þ¤»¤ó¡£°ìÄê¤Îµ¬Â§¤ò»ý¤Ã¤Æ¤¤¤ë¤è¤¦¤Ç¤Ï¡¢¥×¥ì¥¤¥ä¡¼¤Ë¸«Çˤé¤ì¤¿»þÅÀ¤Ç¡¢¥²¡¼¥à¤È¤·¤Æ¤ÎÌò³ä¤ò²Ì¤¿¤µ¤Ê¤¯¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£¤µ¤Æ¡¢°ÊÁ°¤Î¹ÖºÂ¤Ç¡¢¤³¤Î¤è¤¦¤Ê¾ì¹ç¤Ë¤Ï¤É¤¦¤·¤¿¤é¤¤¤¤¤«¡¢²òÀâ¤ò¤·¤¿¤Î¤Ç¤¹¤¬³Ð¤¨¤Æ¤¤¤ë¤Ç¤·¤ç¤¦¤«¡£


¢£Íð¿ô¤Î½àÈ÷

¤³¤¦¤¤¤Ã¤¿¥±¡¼¥¹¤Ç¤Ï¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤Ë¡ØÍð¿ô¡Ù¤ò¼è¤êÆþ¤ì¤ë¤Î¤¬¤¤¤¤¤Ç¤·¤ç¤¦¡£Íð¿ô¤Ë¤Ä¤¤¤Æ¤Ï¡¢°ÊÁ°¤Î¹ÖºÂ¡Ø£Ã£è£á£ð£ô£å£ò.£±£² [ Íð¿ô ]¡Ù¤Ç¾Ü¤·¤¯¼è¤ê¾å¤²¤Æ¤¤¤Þ¤¹¤«¤é¡¢¤è¤¯¤ï¤«¤é¤Ê¤¤¤È¤¤¤¦¿Í¤Ï¡¢¤½¤Á¤é¤Çͽ½¬¤·¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£

Íð¿ô¤òÀ¸À®¤¹¤ë¤Ë¤Ï¡ØRnd´Ø¿ô¡Ù¤ò»È¤¦¤ó¤Ç¤·¤¿¤Í¡£
Rnd´Ø¿ô¤Ï¡¢Ëè²ó°Û¤Ê¤ë¿ôÃͤòÊÖ¤·¤Æ¤¯¤ì¤ë´Ø¿ô¤Ç¤¹¡£¤¿¤À¤·¡¢Ê֤äƤ¯¤ë¿ô»ú¤Ï¡Ø£°°Ê¾å¤Ç¡¢£±¤è¤ê¤â¾®¤µ¤¤¡Ù¿ôÃͤǤ·¤¿¡£¤Ä¤Þ¤ê¡Ø£°¡Á£°.£¹£¹£¹£¹£¹£¹¡Ä¡Ä¡Ù¤ÎÈϰϤ˸¤é¤ì¤Þ¤¹¡£

¤¸¤ã¤ó¤±¤ó¤ÎÌò¤Ï£±¡Á£³¤ÎÈϰϤ˸ÂÄꤵ¤ì¤Æ¤¤¤Þ¤¹¤«¤é¡¢À¸À®¤µ¤ì¤ëÍð¿ô¤¬£±¡Á£³¤ÎÈϰϤ˸ÂÄê¤Ç¤­¤ì¤Ð¡¢¤¦¤Þ¤¯¥²¡¼¥à¤ËÍð¿ô¤òÁȤ߹þ¤à¤³¤È¤¬¤Ç¤­¤½¤¦¤Ç¤¹¤Í¡£Ëè²ó£±¤«£²¤«£³¤Î¤É¤ì¤«¤¬¡¢¥é¥ó¥À¥à¤ËÀ¸À®¤µ¤ì¤ë¤è¤¦¤Ë¤¹¤ì¤Ð¡¢¤½¤Î¿ôÃͤò»È¤Ã¤Æ¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤ò·è¤á¤ë¤³¤È¤¬¤Ç¤­¤ë¤È¤¤¤¦¤ï¤±¤Ç¤¹¡£

¤½¤³¤Ç¡¢Int´Ø¿ô¤òÁȤ߹ç¤ï¤»¤Æ¡¢°Ê²¼¤Î¤è¤¦¤Ë¥³¡¼¥É¤òµ­½Ò¤·¤Þ¤¹¡£

¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò = Int(Rnd * 3) + 1

¤³¤³¤Ç¤Ï¡¢¾®¿ôÅÀ°Ê²¼¤Î¿ôÃͤòÀÚ¤ê¼Î¤Æ¤ë¡ØInt´Ø¿ô¡Ù¤È¡¢Íð¿ô¤òÀ¸À®¤¹¤ë¡ØRnd´Ø¿ô¡Ù¤òÁȤ߹ç¤ï¤»¤ë¤³¤È¤Ë¤è¤Ã¤Æ¡¢£±¡Á£³¤ÎÈϰϤÇÍð¿ô¤òȯÀ¸¤µ¤»¤Æ¤¤¤Þ¤¹¡£Rnd´Ø¿ô¤Ë³Ý¤±»»¤·¤Æ¤¤¤ë¿ô»ú¤òÁý¤ä¤»¤Ð¡¢¤â¤Ã¤ÈÂ礭¤ÊÈϰϤÇÍð¿ô¤òÀ¸À®¤¹¤ë¤³¤È¤â¤Ç¤­¤Þ¤¹¡£²¾¤Ë¾å¤Î¥³¡¼¥É¤Ç¡¢³Ý¤±»»¤·¤Æ¤¤¤ë¿ôÃͤò£±£°¤Ë¤¹¤ì¤Ð£±¡Á£±£°¤ÎÈϰϤÇÍð¿ô¤ò¼èÆÀ¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£

¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤ò·è¤á¤ëÉôʬ¤Ï¡¢¤³¤Î¤è¤¦¤ËÍð¿ô¤ò¤¦¤Þ¤¯À¸À®¤¹¤ë¤³¤È¤¬¤Ç¤­¤ì¤Ð¥¯¥ê¥¢¤Ç¤¹¡£Íð¿ô¤òÀ¸À®¤¹¤ë¤È¤³¤í¤Þ¤Ç¤ò¼ÂºÝ¤Ëµ­½Ò¤·¤Æ¤ß¤Þ¤·¤ç¤¦¡£Á°²ó¤Î¹ÖºÂ¤Ç¡¢¥µ¥Ö¥×¥í¥·¡¼¥¸¥ã¡ØHyouji¡Ù¤òµ­½Ò¤·¤¿É¸½à¥â¥¸¥å¡¼¥ë¤Ë¡¢¼¡¤Î¤è¤¦¤Ëµ­½Ò¤·¤Þ¤¹¡£

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

¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤Ç¤Ï¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤òÆþ¤ì¤Æ¤ª¤¯¤¿¤á¤ÎÊÑ¿ô¤¬É¬ÍפǤ¹¡£¤½¤³¤Ç»Ï¤á¤Ë¡ØCPU¡Ù¤È¤¤¤¦Ì¾Á°¤ÎÊÑ¿ô¤òÀë¸À¤·¤Æ¤¤¤Þ¤¹¡£
½ÅÍפʤΤϡ¢Íð¿ô¤òÀ¸À®¤¹¤ë¤È¤­¤Ë¡¢£±¤«£²¤«£³¤ÎÈϰϤÇÍð¿ô¤òÀ¸À®¤¹¤ë¤È¤¤¤¦¤³¤È¤Ï¡¢ÊÑ¿ôCPU¤ÏÀ°¿ô¤À¤±¤ò°·¤¦ÊÑ¿ô¤À¤È¤¤¤¦¤³¤È¤Ç¤¹¡£¾®¿ôÅÀ°Ê²¼¤Î¿ôÃͤò°·¤¦É¬Íפ¬¤Ê¤¤¤Î¤Ç¡¢ÊÑ¿ô¤ÏÀ°¿ô·¿¤Ç¤¢¤ëInteger·¿¤ÇÀë¸À¤·¤Æ¤ª¤­¤Þ¤¹¡£

¤³¤Î¥³¡¼¥É¤ò¼Â¹Ô¤¹¤ë¤È¡¢ÊÑ¿ôCPU¤Ë¤Ï¡¢£±¤«£²¤«£³¤Î¤É¤ì¤«¤¬Æþ¤ê¤Þ¤¹¡£¤É¤Î¿ôÃͤ¬Æþ¤ë¤«¤Ï¡¢Íð¿ô¤ò»È¤Ã¤Æ¤¤¤ë¤Î¤ÇËè²óÊѤï¤ê¤Þ¤¹¡£
¤³¤³¤Ç¤Ï¡¢¤¿¤á¤·¤Ë¥á¥Ã¥»¡¼¥¸¤òɽ¼¨¤·¤Æ¡¢Æ°ºî¤¬³Îǧ¤Ç¤­¤ë¤è¤¦¤Ë¤·¤Æ¤¤¤Þ¤¹¡£¼ÂºÝ¤Ë¥³¡¼¥É¤ò¼Â¹Ô¤·¤Æ¡¢¤É¤Î¤è¤¦¤Ê¥á¥Ã¥»¡¼¥¸¤¬É½¼¨¤µ¤ì¤ë¤«¥Æ¥¹¥È¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£Ëè²ó°Û¤Ê¤ë¿ô»ú¤¬É½¼¨¤µ¤ì¤ì¤ÐÀ®¸ù¤Ç¤¹¡£


¢£¤Á¤ç¤Ã¤È¾å¤¤¤¯Íð¿ô¥Æ¥¯¥Ë¥Ã¥¯

¤³¤³¤Þ¤Ç¤¯¤ë¤È¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤ò·è¤á¤ë¤È¤³¤í¤Þ¤Ç¤Ï¥¯¥ê¥¢¤Ç¤­¤Þ¤·¤¿¡£
¤¿¤À¤·¡¢¼Â¤Ï¤³¤Î¥³¡¼¥É¡¢´°àú¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£½ÅÂç¤Ê·çÅÀ¤¬Àø¤ó¤Ç¤¤¤ë¤Î¤Ç¤¹¡£¤½¤ì¤Ï¡ØÍð¿ô¤Î¼ï¡Ù¤Ë´Ø·¸¤·¤Æ¤¤¤Þ¤¹¡£

Rnd´Ø¿ô¤Ï¡¢Íð¿ô¤òȯÀ¸¤µ¤»¤ë´Ø¿ô¤Ç¤¹¡£¤·¤«¤·¤½¤ÎÍð¿ô¤ÎÀ¸À®ÊýË¡¤Ï¼Â¤Ï°ìÄê¤Îµ¬Â§¤Ë¤Î¤Ã¤È¤Ã¤Æ¤¤¤Þ¤¹¡£¤ï¤«¤ê¤ä¤¹¤¯¸À¤¦¤È¡ØRnd´Ø¿ô¤òÍѤ¤¤¿¥³¡¼¥É¤Ï²¿ÅٸƤӽФ·¤Æ¤âËè²óƱ¤¸Íð¿ô¤¬À¸À®¤µ¤ì¤ë¡Ù¤È¤¤¤¦¤³¤È¤Ç¤¹¡£

¤³¤ì¤Ã¤ÆÍð¿ô¤Ë¤Ê¤Ã¤Æ¤Ê¤¤¤¸¤ã¤ó¡ª¡¡¤È¤¤¤¦À¼¤¬Ê¹¤³¤¨¤Æ¤­¤½¤¦¤Ç¤¹¤¬¡¢¤³¤ì¤Ï»ö¼Â¤Ç¤¹¡£¤³¤ì¤Ï¡¢Rnd´Ø¿ô¤¬¡Ø¥·¡¼¥ÉÃ͡٤Ȥ¤¤¦¥Ñ¥é¥á¡¼¥¿¡¼¤ò¸µ¤ËÍð¿ô¤òÀ¸À®¤·¤Æ¤¤¤ë¤³¤È¤Ë´Ø·¸¤·¤Æ¤¤¤Þ¤¹¡£
¥·¡¼¥ÉÃͤȤ¤¤¦¤Î¤Ï¡¢Íð¿ô¤ÎÀ¸À®¤Ë»È¤ï¤ì¤ë¡ØÍð¿ô¤Î¼ï¡Ù¤Ç¤¹¡£¤³¤Î¥·¡¼¥ÉÃͤò¸µ¤Ë¤·¤ÆÍð¿ô¥¸¥§¥Í¥ì¡¼¥¿¤È¤¤¤¦µ¡¹½¤¬Íð¿ô¤òÀ¸À®¤·¤Þ¤¹¡£Rnd´Ø¿ô¤Ï¡¢¤³¤Î¥·¡¼¥ÉÃͤòÍð¿ô¥¸¥§¥Í¥ì¡¼¥¿¤ËÅϤ¹Ìò³ä¤ò²Ì¤¿¤¹´Ø¿ô¤Ê¤Î¤Ç¤¹¤Í¡£
Rnd´Ø¿ô¤Ï¡¢´ðËÜŪ¤ËÁ°²óÀ¸À®¤·¤¿Íð¿ô¤ò¥·¡¼¥ÉÃͤȤ·¤ÆÍð¿ô¥¸¥§¥Í¥ì¡¼¥¿¤ËÅϤ·¤Þ¤¹¡£¤³¤Î¤¿¤á¡¢Ê£¿ô²ó·«¤êÊÖ¤·¤Æ¤â¡¢Æ±¤¸µ¬Â§À­¤ò»ý¤Ã¤Æ¤·¤Þ¤¦¤³¤È¤Ë¤Ê¤ë¤Î¤Ç¤¹¡£

¤Ê¤ó¤À¤«¤Á¤ç¤Ã¤ÈÆñ¤·¤¤ÏäˤʤäƤ­¤Þ¤·¤¿¤¬¡¢Íפ¹¤ë¤Ë¡¢Íð¿ô¤¬°ìÄê¤Îµ¬Â§¤ò»ý¤Ã¤Æ¤·¤Þ¤¦¤È¤¤¤¦¤³¤È¤Ê¤Î¤Ç¡¢¤³¤ì¤Ï¤Þ¤º¤¤¤Ç¤¹¤Í¡£

¤½¤³¤Ç¤³¤Î¸½¾Ý¤ò²óÈò¤¹¤ëÊýË¡¤¬ÍѰդµ¤ì¤Æ¤¤¤Þ¤¹¡£
¤½¤ì¤Ë¤Ï¡¢Randomize¤È¤¤¤¦¥­¡¼¥ï¡¼¥É¤ò»È¤¤¤Þ¤¹¡£

Randomize¡§

¹½Ê¸
    Randomize
ÀâÌÀ
    ¥·¥¹¥Æ¥à¥¿¥¤¥Þ¡¼¤«¤é¥·¡¼¥ÉÃͤòÀ¸À®¤¹¤ë

Randomize¤Ï¡¢Íð¿ô¥¸¥§¥Í¥ì¡¼¥¿¤ËÅϤµ¤ì¤ë¥·¡¼¥ÉÃͤò¡¢¥·¥¹¥Æ¥à¥¿¥¤¥Þ¡¼(¥¦¥£¥ó¥É¥¦¥º¤ÎÆâÉô¤Ë¤¢¤ë»þ´Ö¤ò´ÉÍý¤¹¤ë¥¿¥¤¥Þ¡¼)¤«¤é½¦¤¦¤è¤¦¤Ë»ØÄꤷ¤Þ¤¹¡£¤³¤ì¤Ë¤è¤ê¡¢Íð¿ô¤Ï¡¢Ê¸»úÄ̤구§À­¤Î¤Ê¤¤¿ôÃͤ¬¥é¥ó¥À¥à¤ÇÊÖ¤µ¤ì¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

¤½¤ì¤Ç¤Ï¡¢Àè¤Û¤É¤Î¥³¡¼¥É¤ò¡¢Randomize¤ò»È¤Ã¤Æ½¤Àµ¤·¤Æ¤ß¤Þ¤·¤ç¤¦¡£

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


Ãí°ÕÅÀ¤È¤·¤Æ¤Ï¡¢Rnd´Ø¿ô¤ò¸Æ¤Ó½Ð¤¹Á°¤Ë¡¢Randomize¤ò¸Æ¤Ó½Ð¤¹¤È¤¤¤¦¤³¤È¤ËÃí°Õ¤·¤Þ¤¹¡£¤¢¤È¤«¤éRandomize¤ò¸Æ¤Ó½Ð¤·¤Æ¤â̵°ÕÌ£¤Ç¤¹¤Î¤Çµ¤¤ò¤Ä¤±¤Þ¤·¤ç¤¦¡£

¤³¤ì¤Ç¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤Ï¡¢ËÜÅö¤Î°ÕÌ£¤ÇËè²ó°Û¤Ê¤ë¤â¤Î¤Ë¤Ê¤ê¤Þ¤·¤¿¡£¤³¤ì¤Ë¤è¤ê¡¢¥×¥ì¥¤¥ä¡¼¤¬¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤òͽ¬¤¹¤ë¤³¤È¤¬Æñ¤·¤¯¤Ê¤ê¡¢¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¤È¤·¤Æ¤Î´°À®ÅÙ¤¬¾å¤¬¤ê¤Þ¤·¤¿¤Í¡£


¢£³Ê¸À

¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤òÍð¿ô¤Ç·è¤á¤ë
Íð¿ô¤òÀ¸À®¤¹¤ë¤Ë¤ÏRandomize¤òÊ»ÍÑ


´°Á´¤Ê¥é¥ó¥À¥à¤È¤¤¤¦¤Î¤Ï¤³¤¦¤ä¤Ã¤Æ¼ÂÁõ¤¹¤ë¤Î¤Ç¤¹¡£






Comment

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

Track back

£±£°Ç¯¶á¤¯¤âÁ°¤Ë¸½ºß¤Î¾ðÊ󵻽ѤÎÍ­ÍͤòÁÛÁü¤·¤Æ¤¤¤¿¡¢¶Ã¤¯¤Ù¤­À踫À­¤Ç¤¹¡£¥Þ¥¤¥¯¥í¥½¥Õ¥È¤¬¤³¤ì¤À¤±µðÂç¤Ë¤Ê¤ì¤¿¤Î¤âð÷¤±¤ëµ¤¤¬¤·¤Þ¤¹¡££²£°£°£·Ç¯¸½ºß¤Ç¤Ï¡¢Åö¤¿¤êÁ°¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤Ã¤¿¤³¤È¤Ð¤«¤ê¤¬½ñ¤¤¤Æ¤¢¤ë¤Î¤ÇÆÉ¤ßʪ¤È¤·¤ÆÆÉ¤à¤Ë¤Ï¡¢¤Á¤ç¤Ã¤È¾éŤǤ¹¡£¤¿¤À¡¢¾ðÊó²½...
  • ¥³¥ó¥Ô¥å¡¼¥¿¤ò¶Ë¤á¤ë
  • 2007.09.26(Wed)

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



¥×¥í¥°¥é¥ß¥ó¥°¤ä 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