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

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

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



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


£Ã£è£á£ð£ô£å£ò.£¶£´ [ ¥é¥¸¥¢¥ó¤Î³èÍÑ¡§Ç¤°Õ¤Î³ÑÅÙ¤Ø°ÜÆ°¤¹¤ë ]

¢£³ÑÅÙ¤ò·è¤á¤Æ°Üư¤¹¤ë

Á°²ó¤Ï¥é¥¸¥¢¥ó¤ò»È¤Ã¤Æ¡¢±ß±¿Æ°¤ò¹Ô¤¤¤Þ¤·¤¿¡£
¤¢¤ëÅÀ¤òÃæ¿´¤È¤·¤Æ¡¢¤½¤Î¼þ¤ê¤ò±ß¤òÉÁ¤¯¤è¤¦¤Ë°Üư¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤·¤¿¤Í¡£

º£²ó¤Ï¤³¤ì¤ò±þÍѤ·¤Æ¡¢Ç¤°Õ¤ÎÊý³Ñ¤Ø¸þ¤«¤Ã¤Æ¤Þ¤Ã¤¹¤°¤Ë°Üư¤¹¤ë¥×¥í¥°¥é¥à¤òºî¤Ã¤Æ¤ß¤Þ¤·¤ç¤¦¡£¼Â¤ÏÁ°²ó¤Î¹ÖºÂ¤Ç²òÀ⤷¤¿ÆâÍÆ¤òÍý²ò¤·¤Æ¤¤¤ì¤Ð¡¢º£²ó¤ÎÆâÍÆ¤Ï¤µ¤Û¤ÉÆñ¤·¤¯¤¢¤ê¤Þ¤»¤ó¡£Æ¬¤ò½À¤é¤«¤¯¤·¤Æ¥Á¥ã¥ì¥ó¥¸¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£

¤µ¤Æ¡¢¤½¤ì¤Ç¤Ï±ß±¿Æ°¤È¡¢Ç¤°Õ¤Î³ÑÅ٤Ǥޤ乤°°Üư¤¹¤ë¤³¤È¤È¡¢¤½¤³¤Ë¤Ï°ìÂΤɤó¤Ê´Ø·¸¤¬¤¢¤ë¤Î¤Ç¤·¤ç¤¦¤«¡£¤Ê¤ó¤È¤Ê¤¯³ÑÅÙ¤¬´Ø·¸¤·¤Æ¤¤¤ë¤È¤¤¤¦¤³¤È¤ÏÁÛÁü¤Ç¤­¤Þ¤¹¤Í¡£

±ß±¿Æ°¤ò¤¹¤ë¤È¤­¤Ï¡¢°ÜưÀè¤ÎºÂɸ¤ò¡¢¾¯¤·¤º¤Ä³ÑÅÙ¤òÁý¤ä¤·¤Ê¤¬¤éϢ³¤·¤Æ½èÍý¤¹¤ë¤³¤È¤Ç¼Â¸½¤·¤Þ¤·¤¿¡£°ìÈֺǽé¤Ï£±Å٤κÂɸ¤Ë¡¢¼¡¤Ï£²Å٤κÂɸ¤Ë¡¢¼¡¤Ï¤Þ¤¿¤â¤¦¾¯¤·Áý¤ä¤·¤¿ºÂɸ¤Ë¡Ä¡Ä¤È¤¤¤¦¶ñ¹ç¤Ë¡¢¾¯¤·¤º¤Ä°ÜưÀè¤ÎºÂɸ¤òÊѤ¨¤ë¤³¤È¤Ç¡¢±ß¤òÉÁ¤¤¤Æ¤¤¤ë¤è¤¦¤Ê°Üư¤ò¼Â¸½¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤·¤¿¤Í¡£

Ǥ°Õ¤ÎÊý³Ñ¤Ø°Üư¤µ¤»¤ë¤È¤¤¤¦¤³¤È¤Ï¡¢±ß±¿Æ°¤È¤Ï°ã¤Ã¤Æ¡¢¤º¤Ã¤ÈƱ¤¸Êý¸þ¤Ø¸þ¤«¤Ã¤Æ°Üư¤¹¤ì¤Ð¤¤¤¤¤Ç¤¹¤Í¡£¤È¤¤¤¦¤³¤È¤Ï¡¢Ëè²óƱ¤¸³ÑÅÙ¤ÎÊý¸þ¤Ø¸þ¤«¤Ã¤Æ°Üư¤µ¤»Â³¤±¤ì¤Ð¡¢¤½¤ì¤ÇǤ°Õ¤ÎÊý³Ñ¤Ø¸þ¤«¤Ã¤Æ°Üư¤µ¤»¤ë¤³¤È¤¬¤Ç¤­¤ë¤Ï¤º¤Ç¤¹¡£


¢£Éü½¬

¤½¤ì¤Ç¤Ï´Êñ¤Ë¥é¥¸¥¢¥ó¤Ë¤Ä¤¤¤ÆÉü½¬¤·¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£

¥é¥¸¥¢¥ó¤È¤Ï¡¢¸ÌÅÙË¡¤È¸Æ¤Ð¤ì¤ë³ÑÅ٤ιͤ¨Êý¤Îñ°Ì¤Ç¤·¤¿¤Í¡£±ß¤¬£³£¶£°ÅÙ¤Çɽ¸½¤µ¤ì¤ëÅÙ¿ôË¡¤È¤Ï¡¢Á´¤¯°Û¤Ê¤ë³ÑÅÙ¤Îñ°Ì¤Ç¡¢Æâ³Ñ¤È¸Ì¤ÎÈæÎ¨¤«¤éµá¤á¤é¤ì¤ë³ÑÅ٤ιͤ¨Êý¤Ç¤¹¡£

¤½¤·¤Æ¡¢ÅÙ¿ôË¡¤Î¡ØÅÙ¿ô¡Ù¤«¤é¡¢¸ÌÅÙË¡¤Î¡Ø¥é¥¸¥¢¥ó¡Ù¤òµá¤á¤ë¤Ë¤Ï¡¢¼¡¤Î¤è¤¦¤Ê¸ø¼°¤ò»È¤¨¤Ð¤è¤«¤Ã¤¿¤Î¤Ç¤·¤¿¤Í¡£

ÅÙ¿ô¢Í¥é¥¸¥¢¥ó ¤ÎÊÑ´¹¸ø¼°

    rad = ang * 3.14 / 180

    rad¡Ä¡Ä¥é¥¸¥¢¥ó
    ang¡Ä¡ÄÅÙ¿ô

ang ¤ÎÉôʬ¤Ë¹¥¤­¤Ê³ÑÅÙ¤òÆþ¤ì¤Æ¡¢¾å¤Î¼°¤ò·×»»¤¹¤ë¤È¡¢¤½¤ì¤ËÂбþ¤·¤¿¥é¥¸¥¢¥ó¤ÎÃͤòÆÀ¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£¤³¤³¤Ç¼èÆÀ¤·¤¿¥é¥¸¥¢¥ó¤ò»È¤Ã¤Æ¡¢¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤ò·×»»¤¹¤ë¤È¡¢ÌÜŪ¤Î³ÑÅ٤ˤɤΤ¯¤é¤¤°Üư¤¹¤ì¤Ð¤¤¤¤¤Î¤«¤¬¤ï¤«¤ê¤Þ¤¹¡£

º£¸½ºß¤Î°ÌÃÖ¤¬¡¢²£°ÌÃÖ X ¡¢½Ä°ÌÃÖ Y ¡¢¤Çɽ¤µ¤ì¤ë¤È¤­¡¢Ç¤°Õ¤Î³ÑÅÙ¤ÎÊý³Ñ¤Ø°Üư¤·¤¿ºÂɸ¤òÆÀ¤ë¤Ë¤Ï¡¢¼¡¤Î¤è¤¦¤Ë¤·¤Þ¤¹¡£

¸½ºß¤ÎºÂɸ( X , Y )

°ÜưÀè¤Î²£°ÌÃÖ = X + °Üư¤¹¤ëÎÌ * Cos(¥é¥¸¥¢¥ó)

°ÜưÀè¤Î½Ä°ÌÃÖ = Y + °Üư¤¹¤ëÎÌ * Sin(¥é¥¸¥¢¥ó)

¤³¤³¤Ç½ÅÍפʤΤϡ¢¡Ø²£¤Î°ÜưÎ̤ò·×»»¤¹¤ë¤È¤­¤Ë¤Ï¥³¥µ¥¤¥ó(Cos)¤ò»È¤¦¡Ù¡¢¡Ø½Ä¤Î°ÜưÎ̤ò·×»»¤¹¤ë¤È¤­¤Ë¤Ï¤ò¥µ¥¤¥ó(Sin)»È¤¦¡Ù¤È¤¤¤¦¥ë¡¼¥ë¤Ç¤¹¡£¤½¤ì¤µ¤¨¤ï¤«¤Ã¤Æ¤¤¤ì¤Ð¡¢¾å¤Î¼°¤ÎÄ̤ê¤Ë·×»»¤¹¤ì¤Ð¡¢Ç¤°Õ¤ÎÊý³Ñ¤Ø¸þ¤«¤Ã¤Æ°Üư¤¹¤ë¤È¤¤¤¦·×»»¤¬´Êñ¤Ë¤Ç¤­¤Þ¤¹¡£

¤³¤ì¤ò¤Þ¤È¤á¤ë¤È¡¢³ÑÅ٤ˤè¤ë·×»»¤ò¹Ô¤¦¾ì¹ç¤Ë¤Ï¡¢¼¡¤Î¤è¤¦¤Êή¤ì¤Ç·×»»¤¹¤ì¤Ð¤¤¤¤¤Î¤Ç¤¹¤Í¡£

²¿Å٤γÑÅÙ¤Ç°ÜÆ°¤¹¤ë¤«·è¤á¤ë(¤³¤ÎÎã¤Ç¤Ï45ÅÙ)

    ang = 45

³ÑÅÙ¤«¤é¥é¥¸¥¢¥ó¤òµá¤á¤ë

    rad = ang * 3.14 / 180

¥é¥¸¥¢¥ó¤ò¸µ¤Ë½Ä²£¤Î°ÜưÎ̤òµá¤á¤ë

    °ÜưÀè²£ºÂɸ = ¸½ºß¤Î²£°ÌÃÖ + °Üư¤¹¤ëÎÌ * Cos(rad)
    °ÜưÀè½ÄºÂɸ = ¸½ºß¤Î½Ä°ÌÃÖ + °Üư¤¹¤ëÎÌ * Sin(rad)

±ß±¿Æ°¤Î»þ¤Ë¤Ï¡¢ang ¤ËÆþ¤ë³ÑÅÙ¤ò¾¯¤·¤º¤ÄÁý¤ä¤·¤Ê¤¬¤éϢ³¤·¤Æ½èÍý¤·¤Þ¤·¤¿¡£°Üư¤¹¤ëÎ̤¬°ìÄê¤Ç¤¢¤ì¤Ð¡¢°ÜưÀè¤ÎºÂɸ¤Î³ÑÅÙ¤À¤±¤¬ÊѲ½¤¹¤ë¤Î¤Ç¡¢¤Þ¤ë¤Ç¥³¥ó¥Ñ¥¹¤Ç±ß¤òÉÁ¤¯¤È¤­¤Î¤è¤¦¤Ë¡¢°ÜưÀ褬ÊѲ½¤·¤Þ¤·¤¿¡£

Ǥ°Õ¤Î³ÑÅ٤ظþ¤«¤Ã¤Æ¤Þ¤Ã¤¹¤°°Üư¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢³ÑÅÙ¤¬ÅÓÃæ¤ÇÊѤï¤Ã¤Æ¤·¤Þ¤Ã¤Æ¤ÏÊѤǤ¹¤Í¡£¤Ç¤¹¤«¤é¡¢¸½ºß¤Î²£°ÌÃ֤䡢¸½ºß¤Î½Ä°ÌÃÖ¤ò¾ï¤Ë¹¹¿·¤·¤Ê¤¬¤é½èÍý¤·¤Æ¤¤¤­¤Þ¤¹¡£

Sub MoveBall(ang As Long)
    
    Dim rad As Single '¥é¥¸¥¢¥ó
    Dim X As Single '¥Ü¡¼¥ë¤ÎºÂɸ¡¡²£°ÌÃÖ
    Dim Y As Single '¥Ü¡¼¥ë¤ÎºÂɸ¡¡½Ä°ÌÃÖ
    
    Dim SPEED As Single '°Üư¥¹¥Ô¡¼¥É
    Dim STIME As Long 'Ʊ´ü½èÍý¤ò¹Ô¤¦¤¿¤á¤Ë»È¤¦
    Dim FLG As Boolean '¥ë¡¼¥×½ªÎ»¥Õ¥é¥°
    Const PI As Single = 3.14159 '±ß¼þΨ
    
    X = 100 'ºÇ½é¤Î²£°ÌÃÖºÂɸ¤òÀßÄê
    Y = 100 'ºÇ½é¤Î½Ä°ÌÃÖºÂɸ¤òÀßÄê
    
    FLG = False
    SPEED = 3 '°Üư¥¹¥Ô¡¼¥É¤òÀßÄê
    rad = ang * PI / 180 '¥é¥¸¥¢¥ó¤òµá¤á¤ë
    
    Do Until FLG
        STIME = GetTickCount
        With UserForm1.Image1
            X = X + SPEED * Cos(rad) '²£°ÌÃÖ¤ò·×»»
            Y = Y + SPEED * Sin(rad) '½Ä°ÌÃÖ¤ò·×»»
            .Left = X - .Width / 2 '¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Î°ÌÃÖÄ´À°
            .Top = Y - .Height / 2 '¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Î°ÌÃÖÄ´À°
            If X > 200 Then FLG = True
            If X < 0 Then FLG = True
            If Y > 200 Then FLG = True
            If Y < 0 Then FLG = True
        End With
        DoEvents
        Do
            Sleep 1
        Loop Until GetTickCount - STIME > 30
    Loop
    
End Sub

Á°²ó¤Î¥µ¥ó¥×¥ë¤ò¾¯¤·¤¤¤¸¤Ã¤¿¤â¤Î¤Ç¤¹¡£

¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤Ï¡¢°ú¿ô¤ò¤Ò¤È¤Ä¼è¤ë¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£

Sub MoveBall(ang As Long)

ang ¤ÎÉôʬ¤ËǤ°Õ¤Î³ÑÅÙ¤ò°ú¿ô¤È¤·¤ÆÅϤ·¤Æ¡¢¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤ò¸Æ¤Ó½Ð¤»¤Ð¤¤¤¤¤Î¤Ç¤¹¤Í¡£

¤³¤Î¥³¡¼¥É¤Ï¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à(UserForm1)¾å¤Ë¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë(Image1)¤¬ÇÛÃÖ¤µ¤ì¤Æ¤¤¤Ê¤¤¤È¤¦¤Þ¤¯¤¤¤­¤Þ¤»¤ó¤Î¤ÇÃí°Õ¤·¤Æ¤¯¤À¤µ¤¤¡£

º£²ó¤â¥µ¥ó¥×¥ë¤òÍѰդ·¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢¤½¤Á¤é¤ò¥À¥¦¥ó¥í¡¼¥É¤·¤ÆÆ°¤«¤·¤Æ¤ß¤ë¤Î¤¬°ìÈ֤狼¤ê¤ä¤¹¤¤¤È»×¤¤¤Þ¤¹¡£
¥µ¥ó¥×¥ë¤Ç¤Ï¡¢¥¹¥Ô¥ó¥Ü¥¿¥ó(SpinButton)¤È¤¤¤¦¥³¥ó¥È¥í¡¼¥ë¤ò³èÍѤ·¤Æ¥³¡¼¥É¤òÁȤó¤Ç¤¤¤Þ¤¹¡£

370.gif

¥¹¥Ô¥ó¥Ü¥¿¥ó¤ò»È¤Ã¤Æ¡¢¹¥¤­¤Ê³ÑÅÙ¤ò»ØÄꤹ¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£³ÑÅÙ¤ò·è¤á¤Æ¡¢¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤ò²¡¤¹¤È¡¢¥Ü¡¼¥ë¤¬¤½¤ÎÊý³Ñ¤Ø¸þ¤«¤Ã¤Æ°Üư¤·¤Þ¤¹¡£
»ØÄê¤Ç¤­¤ë³ÑÅ٤ϡ¢ºÇÄ㤬£±ÅÙ¡¢ºÇÂ礬£³£¶£°Å٤Ǥ¹¡£¿§¡¹Êѹ¹¤·¤Æ¤ä¤Ã¤Æ¤ß¤ë¤ÈÌÌÇò¤¤¤È»×¤¤¤Þ¤¹¡£

371.gif


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



¢£³Ê¸À

³ÑÅÙ¤òÊѤ¨¤º¤Ë°Üư¤¹¤ì¤Ð¼Ð¤á¤Ë¤â°Üư¤Ç¤­¤ë
¥·¥å¡¼¥Æ¥£¥ó¥°¤ä¥¢¥¯¥·¥ç¥ó¤Ë³èÍѤǤ­¤ë


±ß±¿Æ°¤è¤ê¤â¡¢¼Â¤Ï´Êñ¤«¤â¤·¤ì¤Þ¤»¤ó¤Í¡£







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¥¹¥Æ¡¼¥È¥á¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£± [ ¥Ð¥¤¥È¤È¥Ó¥Ã¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£² [ ¥¦¥£¥ó¥É¥¦¥á¥Ã¥»¡¼¥¸¤È¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¸£³ [ ʸ»úÎó¤Î´ðÁà ]
    £Ã£è£á£ð£ô£å£ò.£¸£´ [ ʸ»úÎóÁàºî­¡ ]
    £Ã£è£á£ð£ô£å£ò.£¸£µ [ ʸ»úÎóÁàºî­¢ ]
    £Ã£è£á£ð£ô£å£ò.£¸£¶ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£±¡§»ÅÍͤò·è¤á¤ë ]
    £Ã£è£á£ð£ô£å£ò.£¸£· [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£²¡§¥­¡¼ÆþÎϸ¡ÃÎ ]
    £Ã£è£á£ð£ô£å£ò.£¸£¸ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£³¡§Ê¸»úÎó¾È¹ç ]
    £Ã£è£á£ð£ô£å£ò.£¸£¹ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£´¡§È½Äê´Ø¿ô ]
    £Ã£è£á£ð£ô£å£ò.£¹£° [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£µ¡§¥²¡¼¥à²èÌÌÀß·× ]
    £Ã£è£á£ð£ô£å£ò.£¹£± [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£¶¡§ÌäÂêʸ¤Î¥½¡¼¥È ]
    £Ã£è£á£ð£ô£å£ò.£¹£² [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£·¡§Æ°ÅªÇÛÎó ]
    £Ã£è£á£ð£ô£å£ò.£¹£³ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£¸¡§¥­¡¼¥À¥¦¥ó¥¤¥Ù¥ó¥È ]
    £Ã£è£á£ð£ô£å£ò.£¹£´ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£¹¡§ÀµÂÇ¿ô¤Îɽ¼¨ ]
    £Ã£è£á£ð£ô£å£ò.£¹£µ [ ¥¿¥¤¥Ô¥ó¥°¥²¡¼¥à£±£°¡§¥¿¥¤¥à¤Îɽ¼¨ ]
    £Ã£è£á£ð£ô£å£ò.£¹£¶ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£±¡§¥¤¥Ù¥ó¥È¤Î¼ïÎà ]
    £Ã£è£á£ð£ô£å£ò.£¹£· [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£²¡§²èÌÌÀß·× ]
    £Ã£è£á£ð£ô£å£ò.£¹£¸ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£³¡§¥¯¥ê¥Ã¥¯ºÂɸ¸¡ÃÎ ]
    £Ã£è£á£ð£ô£å£ò.£¹£¹ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£´¡§¥­¥ã¥é¥¯¥¿¡¼½àÈ÷ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£° [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£µ¡§¥­¥ã¥é¥¯¥¿¡¼¤ÎÇÛÃÖ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£± [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£¶¡§¥­¥ã¥é¥¯¥¿¡¼°Üư¤ÈNot±é»»»Ò ]
    £Ã£è£á£ð£ô£å£ò.£±£°£² [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£·¡§¥¯¥ê¥Ã¥¯¤Î¥Ò¥Ã¥ÈȽÄê ]
    £Ã£è£á£ð£ô£å£ò.£±£°£³ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£¸¡§¥Ò¥Ã¥È¥Þ¡¼¥¯¥¨¥Õ¥§¥¯¥È ]
    £Ã£è£á£ð£ô£å£ò.£±£°£´ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£¹¡§¥µ¥¦¥ó¥É½èÍý¤Î¼ÂÁõ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£µ [ ¥¯¥ê¥Ã¥¯¥²¡¼¥à£±£°¡§¥Þ¥¦¥¹¥«¡¼¥½¥ë¤ÎÊѹ¹ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£¶ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£±¡§»ÅÍͤȳµÍפò·è¤á¤ë ]
    £Ã£è£á£ð£ô£å£ò.£±£°£· [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£²¡§´ðËܳµÇ°¤Î³Îǧ ]
    £Ã£è£á£ð£ô£å£ò.£±£°£¸ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£³¡§¥Ù¥¯¥È¥ë¤È¤Ï ]
    £Ã£è£á£ð£ô£å£ò.£±£°£¹ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£´¡§ÊÑ¿ô¤äÄê¿ô¤ÎÀë¸À ]
    £Ã£è£á£ð£ô£å£ò.£±£±£° [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£µ¡§½é´ü²½½èÍý¤Î¼ÂÁõ ]
    £Ã£è£á£ð£ô£å£ò.£±£±£± [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£¶¡§¥Ö¥í¥Ã¥¯¤ÎÇÛÃÖ ]
    £Ã£è£á£ð£ô£å£ò.£±£±£² [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£·¡§º¬´´½èÍý¤È¥Ð¡¼¤Î½èÍý ]
    £Ã£è£á£ð£ô£å£ò.£±£±£³ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£¸¡§Àþʬ¤ÈÀþʬ¤Î¸òº¹¤òȽÄê ]
    £Ã£è£á£ð£ô£å£ò.£±£±£´ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£¹¡§ÀþʬƱ»Î¤Î¸òÅÀ ]


    ¥³¡¼¥É¤äVBA¤Ë´Ø¤¹¤ë¼ÁÌä¤Ê¤É¤Ï¥µ¥Ý¡¼¥È·Ç¼¨ÈÄ¡ÊÊ̴ۡˤޤǤªµ¤·Ú¤Ë¤É¤¦¤¾¡£




fc2 seotool Excel VBA ¥²¡¼¥à ¥×¥í¥°¥é¥ß¥ó¥° ¹ÖºÂ

By FC2¥Ö¥í¥°

º£¤¹¤°¥Ö¥í¥°¤òºî¤í¤¦¡ª

Powered By FC2¥Ö¥í¥°

Counter

DigitalClock

¥×¥í¥Õ¥£¡¼¥ë

Author:
±Æ»Â
Excel¤ò¤³¤è¤Ê¤¯°¦¤¹¤ë¡£
DirectX¤òËܳÊŪ¤Ë»ÈÍѤ·¤¿VBA¥²¡¼¥à¤Î³«È¯¤ËÀ®¸ù¡£VBA¥²¡¼¥à³¦¤ÎȯŸ¤ò´ê¤¤¡¢Æü¡¹³èÆ°Ãæ¡£

edita


edita.jp¡Ú¥¨¥Ç¥£¥¿¡Û


From Omoituki

VBA ´ØÏ¢½ñÀÒ