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

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

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



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


£Ã£è£á£ð£ô£å£ò.£±£² [ Íð¿ô ]

¢£Íð¿ô

¡ØÍð¿ô¡Ù¤Èʹ¤¤¤Æ¡¢²¿¤Î¤³¤È¤À¤«³§¤µ¤ó¤Ï¤ï¤«¤ê¤Þ¤¹¤«¡£Íð¤ì¤ë¿ô¡¢¤Ä¤Þ¤êÍð¿ô¤È¸À¤¦¤Î¤Ï¥é¥ó¥À¥à¤ËÀ¸À®¤µ¤ì¤ë¿ô¤Î¤³¤È¤ò¸À¤¤¤Þ¤¹¡£
¥²¡¼¥à¤ÈÍð¿ô¤È¤Ï¡¢¼Â¤ÏÀڤäƤâÀÚ¤ì¤Ê¤¤´Ø·¸¤Ë¤¢¤ê¤Þ¤¹¡££Ò£Ð£Ç¤Ê¤É¤Ç¡¢¤É¤ó¤ÊŨ¤¬½Ð¤Æ¤¯¤ë¤«¤ÏËè²ó¥é¥ó¥À¥à¤Ë·è¤Þ¤ê¤Þ¤¹¤è¤Í¡£¤¢¤ì¤âÍð¿ô¤¬´Ø·¸¤·¤Æ¤¤¤Þ¤¹¤·¡¢³ÊÆ®¥²¡¼¥à¤Ê¤É¤Ç¡¢Å¨¤¬·«¤ê½Ð¤·¤Æ¤¯¤ë¹¶·â¤â¡¢¤ä¤Ï¤ê¤½¤Î¤È¤­¤½¤Î¤È¤­¤Ë¤è¤Ã¤Æ°ã¤¤¤Þ¤¹¡£¤³¤ì¤âÍð¿ô¤Ç¤¹¤Í¡£
¤³¤Î¤è¤¦¤Ë¡¢¥²¡¼¥à¤òºî¤ë¤Ë¤¢¤¿¤Ã¤Æ¡¢Íð¿ô¤òÃΤäƤª¤¯¤³¤È¤ÏÈó¾ï¤Ë½ÅÍפʰÕÌ£¤ò»ý¤Á¤Þ¤¹¡£

¤¸¤ã¤ó¤±¤ó¤ò»×¤¤É⤫¤Ù¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£
¼ÂºÝ¤Ë¤¸¤ã¤ó¤±¤ó¤ò¡¢¥²¡¼¥à¤È¤·¤Æ¥×¥í¥°¥é¥ß¥ó¥°¤¹¤ë¤Ë¤Ï¡¢¤É¤¦¤·¤¿¤é¤¤¤¤¤Ç¤·¤ç¤¦¤«¡£
¤Þ¤º¡¢¥×¥ì¥¤¥ä¡¼¤Î½Ð¤¹Ìò(¥°¡¼¥Á¥ç¥­¥Ñ¡¼)¤Ï¡¢¤Þ¤¡¥×¥ì¥¤¥ä¡¼¼«¿È¤¬¼«Ê¬¤Ç·è¤á¤ë¤«¤é¤¤¤¤¤È¤·¤Æ¤â¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤Î½Ð¤¹Ìò¤Þ¤Ç¡¢¥×¥ì¥¤¥ä¡¼¤¬·è¤á¤Æ¤·¤Þ¤¦¤ï¤±¤Ë¤Ï¤¤¤­¤Þ¤»¤ó¡£¤«¤È¤¤¤Ã¤Æ¡¢²¿¤«¤·¤é°ìÄê¤Î¥Ñ¥¿¡¼¥ó¤Ë¤½¤Ã¤ÆÌò¤ò·è¤á¤Æ¤·¤Þ¤¦¤È¡¢¤¤¤Ä¤«¤Ï¸«Çˤé¤ì¤Æ¤·¤Þ¤¦¤«¤â¤·¤ì¤Þ¤»¤ó¡£
°ìÈÖ¥Ù¥¹¥È¤Ê¤Î¤Ï¡¢¥×¥ì¥¤¥ä¡¼¤¬Ëè²óÌò¤ò¼«Í³¤Ë·è¤á¤ë¤³¤È¤¬¤Ç¤­¡¢¤«¤Ä¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÏËè²ó¥é¥ó¥À¥à¤Ë·è¤á¤é¤ì¤¿Ìò¤ò½Ð¤·¤Æ¤¯¤ë¤³¤È¤Ç¤¹¤Í¡£¤³¤¦¤¤¤Ã¤¿¤È¤­¤Ë³èÌö¤¹¤ë¤Î¤¬¡ØÍð¿ô¡Ù¤Ç¤¹¡£
Íð¿ô¤ò¤¦¤Þ¤¯»È¤Ã¤Æ¡¢¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¤òºîÀ®¤·¤Æ¤ß¤ë¤³¤È¤Ë¤·¤Þ¤·¤ç¤¦¡£


¢£¤¸¤ã¤ó¤±¤ó¤Î»ÅÁȤߤòÀ°Íý¤¹¤ë

¤¸¤ã¤ó¤±¤ó¤Î¥ë¡¼¥ë¤¬¤ï¤«¤é¤Ê¤¤¡¢¤È¤¤¤¦¿Í¤Ï¤¤¤Ê¤¤¤È»×¤¤¤Þ¤¹¡£¤¤¤ï¤æ¤ë»°¤¹¤¯¤ß¤È¸Æ¤Ð¤ì¤ë»ÅÁȤߤò»È¤Ã¤Æ¾¡Éé¤ò·è¤¹¤ë¡¢À¤³¦¶¦Ä̤ÎÍ·¤Ó¤Ç¤¹¡£
¤³¤ì¤ò¥×¥í¥°¥é¥ß¥ó¥°¤·¤Æ¡¢¥²¡¼¥à¤È¤·¤ÆÍ·¤Ö¤¿¤á¤Ë¤Ï¤É¤¦¤¹¤ì¤Ð¤¤¤¤¤Î¤Ç¤·¤ç¤¦¤«¡£´Êñ¤ËÀ°Íý¤·¤Æ¤ß¤ë¤³¤È¤Ë¤·¤Þ¤¹¡£

£±¡§¥×¥ì¥¤¥ä¡¼¤¬¼«Í³¤ËÌò¤òÁª¤Ö¤³¤È¤¬¤Ç¤­¤ë
£²¡§¥³¥ó¥Ô¥å¡¼¥¿¡¼¤Ï¤Ê¤ó¤ÎÌò¤ò½Ð¤·¤Æ¤¯¤ë¤«¤ï¤«¤é¤Ê¤¤
£³¡§ÁÐÊý¤Î½Ð¤·¤¿Ìò¤ò¤â¤È¤Ë¡¢¾¡Éé¤òȽÄꤹ¤ë

ºÇÄã¤Ç¤â¡¢¾å¤Ëµ­¤·¤¿£³¤Ä¤Î¾ò·ï¤¬É¬ÍפǤ¹¤Í¡£
º£²ó¤Î¥Æ¡¼¥Þ¤ÏÍð¿ô¤Ç¤¹¤«¤é¡¢¤Þ¤º¤Ï£²ÈÖÌܤÎÉôʬ¤òɳ²ò¤¤¤Æ¤¤¤¯¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£


¢£¤È¤ê¤¢¤¨¤º¤É¤¦¤¹¤ë¡©

¤Þ¤º¤ÏÍð¿ô¤òÀ¸À®¤¹¤ë»ÅÁȤߤò²òÀ⤷¤Æ¤¤¤­¤Þ¤¹¡£
Íð¿ô¤òÀ¸À®¤¹¤ë¤¿¤á¤Ë¤Ï¡¢¡ØRnd¡Ù¤È¤¤¤¦¥­¡¼¥ï¡¼¥É¤ò»È¤¤¤Þ¤¹¡£
Î㤨¤Ð¡¢¼¡¤Î¤è¤¦¤Ê¥³¡¼¥É¤ò¼Â¹Ô¤¹¤ë¤È¡¢¼Â¹Ô¤¹¤ë¤¿¤Ó¤Ë¡¢Ëè²ó°ã¤Ã¤¿Åú¤¨¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£

Sub Test()
    Dim R As Single
    R = Rnd
    MsgBox R
End Sub


Rnd¤Ï¡¢£°°Ê¾å¤Î¿ôÃͤǡ¢£±¤è¤ê¤â¾®¤µ¤¤¿ôÃͤò¡¢Ëè²ó¥é¥ó¥À¥à¤ËÊÖ¤·¤Þ¤¹¡£¤Ä¤Þ¤ê¡¢ºÇ¤â¾®¤µ¤¤¤È¤­¤Ç£°¤¬¡¢ºÇ¤âÂ礭¤¤¤È¤­¤Ç£°¡¥£¹£¹£¹£¹£¹¡Ä¡Ä¤¬ÆÀ¤é¤ì¤ë¤ï¤±¤Ç¤¹¡£¤â¤·¡¢Integer·¿¤Ê¤É¤Î¡¢À°¿ô¤·¤«°·¤¨¤Ê¤¤ÊÑ¿ô¤ò»È¤Ã¤Æ¤·¤Þ¤¦¤È¡¢¾®¿ôÅÀ°Ê²¼¤¬»Í¼Î¸ÞÆþ¤µ¤ì¤Æ¤·¤Þ¤¦¤Î¤Ç¡¢£°¤«£±¤Î¤É¤Á¤é¤«¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£
¾å¤ÎÎã¤Ç¤Ï¡ØR¡Ù¤È¤¤¤¦ÊÑ¿ô¤òÄêµÁ¤·¤Æ¤¤¤Þ¤¹¡£ÊÑ¿ôR¤Ï¡¢Single¤È¤¤¤¦·¿¤ÇÀë¸À¤µ¤ì¤Æ¤¤¤Þ¤¹¤Í¡££Ã£è£á£ð£ô£å£ò£¶¤Ç¤â²òÀ⤷¤Æ¤¤¤Þ¤¹¤¬¡¢Single¤È¤¤¤¦·¿¤Ï¡¢Ã±ÀºÅÙÉâÆ°¾®¿ôÅÀ·¿¤È¤â¸Æ¤Ð¤ì¡¢Íפ¹¤ë¤Ë¾®¿ôÅÀ°Ê²¼¤Î¿ôÃͤò°·¤¦¤³¤È¤¬¤Ç¤­¤ëÊÑ¿ô¤Î·¿¤Ç¤¹¡£¤³¤ÎSingle·¿¤ÎÊÑ¿ô¤òÍѤ¤¤ë¤³¤È¤Ë¤è¤Ã¤Æ¡¢Rnd¤¬ÊÖ¤·¤Æ¤¯¤ë·ë²Ì¤ò¾Ü¤·¤¯Àµ³Î¤ËÃΤ뤳¤È¤¬¤Ç¤­¤ë¤Î¤Ç¤¹¡£

Rnd¡§

¹½Ê¸
    Rnd()
ÀâÌÀ
    £°°Ê¾å¡¢£±Ì¤Ëþ¤Î¿ôÃͤòÊÖ¤¹
    ÊÖ¤µ¤ì¤ë¿ôÃͤϡ¢Ëè²ó¥é¥ó¥À¥à¤ËÀ¸À®¤µ¤ì¤ë


¢£¤¸¤ã¤ó¤±¤ó¥²¡¼¥à¤ò¹Í¤¨¤ë

Íð¿ô¤òºî¤ë¤Ë¤Ï¡¢Rnd¤ò»È¤¦¤È¤¤¤¦¤È¤³¤í¤Þ¤Ç¤ÏÍý²ò¤Ç¤­¤Þ¤·¤¿¤«¡©

¤µ¤Æ¡¢¤¸¤ã¤ó¤±¤ó¤Ç¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤ò¥é¥ó¥À¥à¤ËÊѤ¨¤ë¤¿¤á¤Ë¤Ï¡¢Rnd¤ò¤¦¤Þ¤¯»È¤¨¤Ð¤É¤¦¤Ë¤«¤Ê¤ê¤½¤¦¤Ç¤¹¤¬¡¢¤Þ¤Àº¤¤Ã¤¿ÌäÂ꤬»Ä¤Ã¤Æ¤¤¤Þ¤¹¡£
¤¸¤ã¤ó¤±¤ó¤Ç¤Ï¡¢Ìò¤Î¼ïÎब£³¼ïÎष¤«¤¢¤ê¤Þ¤»¤ó¡£
¥°¡¼¡¢¥Á¥ç¥­¡¢¥Ñ¡¼¤Î£³¼ïÎà¤Ç¤¹¤Í¡£¤·¤«¤·Rnd¤ò»È¤¦¤È¡¢¿§¡¹¤ÊÍð¿ô¤¬È¯À¸¤·¤Æ¤·¤Þ¤¦¤Î¤Ç¡¢²¿À鲿Ëü¤È¤¤¤¦ËÄÂç¤Ê¼ïÎà¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£À¸À®¤µ¤ì¤Æ¤¯¤ëÍð¿ô¤¬£³¼ïÎà¤Ê¤é¡¢¥°¡¼¥Á¥ç¥­¥Ñ¡¼¤Ë¤½¤ì¤¾¤ì¿ôÃͤò¤¢¤Æ¤¬¤¦¤³¤È¤Ë¤è¤Ã¤Æ¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤ò·è¤á¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£¤¿¤È¤¨¤Ð£±¤ò¥°¡¼¡¢£²¤ò¥Á¥ç¥­¡¢£³¤ò¥Ñ¡¼¤È¤¹¤ì¤Ð¡¢¿ôÃͤˤè¤Ã¤Æ¥³¥ó¥Ô¥å¡¼¥¿¡¼¤ÎÌò¤ò·è¤á¤é¤ì¤Þ¤¹¤Í¡£

Rnd¤ò¤Ä¤«¤Ã¤ÆÀ¸À®¤µ¤ì¤ëÍð¿ô¤ò¡¢°ìÄê¤ÎÈϰϤ˸ÂÄꤷ¤¿¤¤¾ì¹ç¤Ë¤Ï¡¢¡ØInt¡Ù¤È¤¤¤¦¥­¡¼¥ï¡¼¥É¤òÊ»ÍѤ¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£

Int¡§

¹½Ê¸
    Int(number)
ÀâÌÀ
    number¤Ç»ØÄꤷ¤¿¿ôÃͤΡ¢¾®¿ôÅÀ°Ê²¼¤ÎÉôʬ¤ò´Ý¤á¤¿·ë²Ì¤òÊÖ¤¹

Int¤Ï¡¢¾®¿ôÅÀ°Ê²¼¤ÎÉôʬ¤òÀÚ¤ê¼Î¤Æ¤Æ¡¢À°¿ôÉôʬ¤À¤±¤òÊÖ¤¹µ¡Ç½¤ò»ý¤Ã¤Æ¤¤¤Þ¤¹¡£Î㤨¤Ð¡¢¡ØInt(1.2345)¡Ù¤È¤¹¤ë¤È¡¢·ë²Ì¤Ï¡Ø1¡Ù¤Ë¤Ê¤ê¤Þ¤¹¡£¡ØInt(9.8765)¡Ù¤Î¾ì¹ç¤À¤È¡Ø9¡Ù¤Ç¤¹¡£¾®¿ôÅÀ°Ê²¼¤ÏÁ´¤ÆÀÚ¤ê¼Î¤Æ¤é¤ì¤ÆÀ°¿ôÉôʬ¤À¤±¤¬¼è¤ê½Ð¤µ¤ì¤Þ¤¹¡£

ñ½ã¤Ë¡¢¡ØInt(Rnd)¡Ù¤È¤·¤Æ¤·¤Þ¤¦¤È¡¢ÀäÂФˣ°¤·¤«ÆÀ¤é¤ì¤Þ¤»¤ó¤Í¡£Rnd¤¬ÊÖ¤¹Íð¿ô¤Ï¡¢ÀäÂФˣ±¤è¤ê¾®¤µ¤¤¿ôÃͤǤ¹¤«¤é¡¢¾®¿ôÅÀ°Ê²¼¤òÀÚ¤ê¼Î¤Æ¤Æ¤·¤Þ¤¦¤È£°¤·¤«Åú¤¨¤¬Ìµ¤¤¤ï¤±¤Ç¤¹¡£
¤½¤³¤Ç¡¢Rnd¤ÎÉôʬ¤Ë³Ý¤±»»¤ò¤·¤Æ¡¢¿ôÃͤÎÈϰϤòÂ礭¤¯¤·¤Æ¤·¤Þ¤¦¤Î¤Ç¤¹¡£¤Á¤ç¤Ã¤È¤ï¤«¤ê¤Å¤é¤¤¤È»×¤¤¤Þ¤¹¤Î¤Ç¡¢°Ê²¼¤ÎÎã¤ò¸«¤Æ¤¯¤À¤µ¤¤¡£
¼°À¸À®¤µ¤ì¤ëÍð¿ô¤ÎÈϰϷë²Ì
Int(Rnd)0¡Á0.99999¡Ä¡Ä0
Int(Rnd*2)0¡Á1.99999¡Ä¡Ä0,1
Int(Rnd*3)0¡Á2.99999¡Ä¡Ä0,1,2
Int(Rnd*10)0¡Á9.99999¡Ä¡Ä0,1,2,3,4,5,6,7,8,9


¤É¤¦¤Ç¤¹¤«¡¢¤Ê¤ó¤È¤Ê¤¯¤ï¤«¤Ã¤Æ¤­¤Þ¤»¤ó¤«¡©
¡ØInt(Rnd*10)¡Ù¤È¤¤¤¦¼°¤Î¾ì¹ç¤Ï¡¢£°¤«¤é£¹¡¥£¹£¹£¹£¹£¹¡Ä¡Ä¤Þ¤Ç¤Î¿ôÃͤ¬Íð¿ô¤È¤·¤ÆÀ¸À®¤µ¤ì¤Þ¤¹¡£¾®¿ôÅÀ°Ê²¼¤Î¿ôÃͤòÀÚ¤ê¼Î¤Æ¤Æ¤·¤Þ¤¦¤È¡¢£°¤«¤é£¹¤Þ¤Ç¤ÎÍð¿ô¤¬ÆÀ¤é¤ì¤ë¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£¤Ä¤Þ¤ê¡¢Rnd¤Ë³Ý¤±»»¤¹¤ë¿ô»ú¤«¤é¡¢£±¤ò°ú¤¤¤¿¿ô¤ÎÍð¿ô¤òȯÀ¸¤µ¤»¤ë¤³¤È¤¬¤Ç¤­¤ë¤Î¤Ç¤¹¡££°¤â´Þ¤á¤ë¤È¡¢³Ý¤±»»¤·¤¿¿ô»úʬ¤Î¼ïÎà¤ÎÍð¿ô¤¬ÆÀ¤é¤ì¤ë¤È¤¤¤¦¤Î¤¬¡¢¤³¤ì¤Ç¤ï¤«¤ë¤È»×¤¤¤Þ¤¹¡£


¢£¤Þ¤È¤á

Rnd¤ÈInt¡¢¤³¤Î£²¤Ä¤Î¥­¡¼¥ï¡¼¥É¤ò»È¤Ã¤Æ¡¢¤¸¤ã¤ó¤±¤ó¤ÎÌò¤ò¥é¥ó¥À¥à¤Ëºî¤ë¤¿¤á¤Ë¤Ï¡¢£³¼ïÎà¤ÎÌò¤¬É¬ÍפǤ¹¡£¤Ç¤¹¤«¤é¼°¤Ï¡ØInt(Rnd*3)¡Ù¤Î¤è¤¦¤Ë¤¹¤ì¤Ð¤¤¤¤¤Ç¤¹¤Í¡£¤¿¤À¤·¡¢¤³¤Î¤ä¤êÊý¤Ç¤ÏÍð¿ô¤ÎÈϰϤ¬£°¤«£±¤«£²¤Ç¤¹¤«¤é¡¢¤Á¤ç¤Ã¤È¤ï¤«¤ê¤Å¤é¤¤¤Ç¤¹¡£ÍýÁÛŪ¤Ê¤Î¤Ï£±¤«£²¤«£³¤Ç¤¹¤è¤Í¡£¤½¤Î¤Û¤¦¤¬ÃÇÁ³¤ï¤«¤ê¤ä¤¹¤¤¡£
¤½¤³¤Ç¡¢¼°¤ò½ñ¤¯¤È¤­¤ËºÇ½é¤Ë£±¤ò­¤·¤Æ¤·¤Þ¤¤¤Þ¤·¤ç¤¦¡£¡ØInt(Rnd*3)+1¡Ù¤È¤·¤Æ¤ª¤±¤Ð¡¢£±¤ò­¤·¤Æ¤¤¤ë¤Î¤ÇÆÀ¤é¤ì¤ëÍð¿ô¤ÎÈϰϤ¬£±¤«£²¤«£³¤Ë¤Ê¤ê¤Þ¤¹¡£¤³¤ì¤Ï´Êñ¤Ç¤¹¤Í¡£

¤µ¤Æ¡¢¤³¤ì¤é¤Î¤³¤È¤òƧ¤Þ¤¨¤Æ¡¢£³¼ïÎà¤ÎÍð¿ô¤òÀ¸À®¤¹¤ë¼°¤ò¥³¡¼¥É¤ò½ñ¤¤¤Æ¤ß¤Þ¤·¤ç¤¦¡£

Sub Ransuu()
    Dim R As Single
    R = Int(Rnd*3)+1
    MsgBox R
End Sub


¤³¤Î¥³¡¼¥É¤ò²¿ÅÙ¤â¼Â¹Ô¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£¥á¥Ã¥»¡¼¥¸¤Èɽ¼¨¤µ¤ì¤ë¿ôÃͤϡ¢É¬¤º£±¤«£²¤«£³¤Î¤É¤ì¤«¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¡£
¤³¤ì¤Ç¡¢¤¸¤ã¤ó¤±¤ó¤Î¤È¤­¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¼¤¬½Ð¤·¤Æ¤¯¤ëÌò¤òËè²ó¥é¥ó¥À¥à¤ËÊѤ¨¤ë¤¿¤á¤Î¡¢Íð¿ô¤Î½àÈ÷¤¬¤Ç¤­¤Þ¤·¤¿¡£


¢£³Ê¸À

Íð¿ô¤È¤ÏËè²ó¥é¥ó¥À¥à¤ËÀ¸À®¤µ¤ì¤ë¿ôÃͤΤ³¤È
Íð¿ô¤òÀ¸À®¤¹¤ë¤¿¤á¤Ë¤ÏRnd¤ò»È¤¦
°ìÄê¤ÎÈϰϤÎÍð¿ô¤òÆÀ¤ë¤¿¤á¤ËInt¤òÊ»ÍѤ¹¤ë


Íð¿ô¤Ï¥²¡¼¥à¤Î´ðËܤΤҤȤĤǤ¹¡£¤·¤Ã¤«¤ê³Ð¤¨¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£





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