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

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

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



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


£Ã£è£á£ð£ô£å£ò.£¶£³ [ ¥é¥¸¥¢¥ó¤Î³èÍÑ¡§±ß±¿Æ° ]

¢£¥é¥¸¥¢¥ó¤Ç¤Ê¤Ë¤¹¤ë¤Î¡©

Á°²ó¤Î¹ÖºÂ¤Ç¥é¥¸¥¢¥ó¤¬¤Ê¤ó¤Ç¤¢¤ë¤«¤ò¡¢¤Ê¤ó¤È¤Ê¤¯²òÀ⤷¤Þ¤·¤¿¡£¿ô³ØÅª¤ÊÏäʤΤǡ¢»ä¤ÎÀâÌÀ¤âɬ¤º¤·¤âÀµ¤·¤¯¤Ï¤Ê¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¡£¤·¤«¤·¡¢¥é¥¸¥¢¥ó¤Ï°ÕÌ£¤è¤ê¤â»È¤¤Êý¤¬Âç»ö¤Ç¤¹¡£Æñ¤·¤¤¿ô³Ø¤ÎÏäϼ¤Ϥɤ¦¤Ç¤â¤è¤¯¤Æ¡¢¥é¥¸¥¢¥ó¤ò¤É¤Î¤è¤¦¤Ë»È¤¨¤Ð¤É¤ó¤Ê¤³¤È¤¬¤Ç¤­¤ë¤Î¤«¡¢ÂçÀڤʤΤϤ½¤Ã¤Á¤Ç¤¹¡£

º£²ó¤Ï¡¢¥é¥¸¥¢¥ó¤Î³èÍÑË¡¤Î¤Ò¤È¤Ä¤È¤·¤Æ¡¢´Êñ¤Ê±ß±¿Æ°¤Î¥×¥í¥°¥é¥à¤òºî¤Ã¤Æ¤ß¤Þ¤·¤ç¤¦¡£º£²ó¤Î¥µ¥ó¥×¥ë¤òÄ̤·¤Æ¡¢¤Ê¤ó¤È¤Ê¤¯¥é¥¸¥¢¥ó¤È¤¤¤¦¤â¤Î¤Î´¶¿¨¤òÄϤó¤Ç¤¤¤¿¤À¤±¤¿¤é¤È»×¤¤¤Þ¤¹¡£


¤½¤ì¤Ç¤Ï¡¢±ß±¿Æ°¤È¤Ï¡¢¶ñÂÎŪ¤Ë¤Ï¤É¤ó¤Ê±¿Æ°¤Ç¤·¤ç¤¦¡£

¼­½ñ¤ËºÜ¤Ã¤Æ¤¤¤ë¡¢Àµ³Î¤Ê°ÕÌ£¤Ç¤Î±ß±¿Æ°¤¬¤É¤Î¤è¤¦¤Ëɽ¤µ¤ì¤Æ¤¤¤ë¤«¤Ï¤ï¤«¤ê¤Þ¤»¤ó¤¬¡¢º£²ó¤Î¹ÖºÂ¤Ç¼è¤ê°·¤¦±ß±¿Æ°¤È¤Ï¡¢¼¡¤Î¤è¤¦¤Ê±¿Æ°¤Î¤³¤È¤ò»Ø¤·¤Þ¤¹¡£

¤¢¤ëÃÏÅÀ¤òÃæ¿´¤È¤·¤Æ¡¢±ß¤òÉÁ¤¯¤è¤¦¤Ëư¤¯¤³¤È

¤Ç¤¹¡£

±ß¤Ë¤Ïɬ¤ºÃæ¿´¤¬¤¢¤ê¤Þ¤¹¡£³§¤µ¤ó¾®³ØÀ¸¤Î¤È¤­¤Ë¥³¥ó¥Ñ¥¹¤Ç±ß¤òÉÁ¤­¤Þ¤·¤¿¤è¤Í¡£¤½¤Î¤È¤­¤Î¤³¤È¤ò»×¤¤½Ð¤·¤Æ¤¯¤À¤µ¤¤¤Í¡£

º£²ó¤Î¥×¥í¥°¥é¥à¤Ç¤Ï¡¢¤Þ¤º½é¤á¤Ë¸¶ÅÀ¤È¤Ê¤ëÃæ¿´Éôʬ¤ò·è¤á¤Æ¤ä¤ê¡¢¤½¤³¤òÃæ¿´¤È¤·¤¿±ß¤òÉÁ¤¯¤è¤¦¤Ê´¶¤¸¤Ç¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤òư¤«¤·¤Æ¤ß¤Þ¤¹¡£


¢£¥Õ¥©¡¼¥à¤Î½àÈ÷

¤½¤ì¤Ç¤Ï¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Î½àÈ÷¤ò¤·¤Þ¤·¤ç¤¦¡£
¤È¤Ï¤¤¤Ã¤Æ¤â¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Ò¤È¤Ä¤È¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤¬¤¢¤ì¤Ð½½Ê¬¤Ç¤¹¡£

ball.gif

¤³¤Î¥Ü¡¼¥ë¤Î²èÁü¤ò¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤Ë¥í¡¼¥É¤·¤Æ¡¢±ß±¿Æ°¤ò¤µ¤»¤Æ¤ß¤Þ¤·¤ç¤¦¡£¤Á¤Ê¤ß¤Ë¤³¤Î²èÁü¤Î¥µ¥¤¥º¤Ï36¡ß36¥Ô¥¯¥»¥ë¤Ç¤¹¡£

¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤ò¿·µ¬¤ËºîÀ®¤·¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ò¤Ò¤È¤ÄÇÛÃÖ¤·¤Þ¤¹¡£¤½¤Î¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ËÀè¤Û¤É¤Î²èÁü¤ò¥í¡¼¥É¤·¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£
¤¢¤È¤Ï¥¹¥¿¡¼¥È¥Ü¥¿¥ó¤ÎÌò³ä¤ò²Ì¤¿¤¹¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤òÇÛÃÖ¤·¤Æ¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Î½àÈ÷¤Ï´°Î»¤Ç¤¹¡£´Êñ¤Ç¤¹¤Í¡£

360.gif

¤³¤ó¤Ê¤«¤ó¤¸¤Ç¤¹¡£


¢£¥µ¥¤¥ó¡¦¥³¥µ¥¤¥ó

¤Þ¤º¡¢º£²ó¤Î¥µ¥ó¥×¥ë¤ò¤¹¤ó¤Ê¤êÍý²ò¤¹¤ë¤¿¤á¤Ë¡¢¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤Ë¤Ä¤¤¤Æ´Êñ¤Ë½ñ¤­¤Þ¤¹¡£¤â¤Á¤í¤ó¡¢¿ô³ØÅª¤Ê°ÕÌ£¤è¤ê¤â¡¢¤ï¤«¤ê¤ä¤¹¤µ¤ò½Å»ë¤·¤¿Ê¸Ì̤Ǥ¹¤Î¤Ç¡¢ºÙ¤«¤¤ÆÍ¤Ã¹þ¤ß¤Ï¤´´ªÊÛ¤ò¡£

¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤Ï¡¢¡Øsin¡¦cos¡Ù¤Èɽ¤µ¤ì¤ë¤³¤È¤¬Â¿¤¤¤Ç¤¹¡£¤³¤ì¤Ï»°³Ñ´Ø¿ô¤ÎÊÙ¶¯¤ò¤¹¤ë¤È½Ð¤Æ¤­¤Þ¤¹¡£»°³Ñ´Ø¿ô¤ÎÏäȤ«¤Ë¤Ê¤ë¤È¡¢Èó¾ï¤Ë̲¤¿¤¯¤Ê¤ê¤½¤¦¤Ê¤Î¤Ç¡¢¤³¤³¤Ç¤Ï¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤Ë¤Ä¤¤¤Æ¡¢¥º¥Ð¥ê¸À¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£

¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤È¤Ï¡¢¥º¥Ð¥ê¡¢³ÑÅÙ¤«¤éµá¤á¤é¤ì¤ë¡¢½Ä²£¤Î°ÜưÎ̤Ǥ¹¡£
¤³¤ì¤Ë¤Ï¡¢Ä¾³Ñ»°³Ñ·Á¤ò»È¤Ã¤Æ¹Í¤¨¤Þ¤¹¡£´Êñ¤Ç¤¹¤«¤é¡¢¤Á¤ç¤Ã¤È¤À¤±¤Ä¤Þ¤é¤Ê¤¤¿Þ·Á¤òį¤á¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£

361.gif

¤Õ¤¿¤Ä¤Î»°³Ñ·Á¤¬Ê¤ó¤Ç¤¤¤Þ¤¹¡£¤½¤·¤Æ¡¢¡Ø¦È(¥·¡¼¥¿)¡Ù¤È½ñ¤«¤ì¤Æ¤¤¤ëÉôʬ¤Î³ÑÅÙ¤¬°Û¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£º¸Â¦¤Î»°³Ñ·Á¤Î¦È¤è¤ê¤â¡¢±¦Â¦¤Î»°³Ñ·Á¤Î¦È¤Î¤Û¤¦¤¬³ÑÅÙ¤¬¾®¤µ¤¯¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£

¤¹¤ë¤È¤É¤¦¤Ç¤·¤ç¤¦¡¢º¸Â¦¤Î»°³Ñ·Á¤Ç¤Ï¡¢ÊÕA¤Î¤Û¤¦¤¬ÊÕB¤è¤ê¤âŤ¤¤Ç¤¹¤Í¡£¤·¤«¤·¡¢±¦Â¦¤Î»°³Ñ·Á¤Ç¤ÏµÕ¤Ë¡¢ÊÕA¤Î¤Û¤¦¤¬ÊÕB¤è¤ê¤âû¤¯¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£

¤³¤Î¤³¤È¤«¤é¡¢¦È¤Î³ÑÅÙ¤¬ÊѤï¤ë¤È¡¢Ä¾³Ñ»°³Ñ·Á¤Î½Ä¤ÎÉý¤È²£¤ÎÉý¤ÎÈæÎ¨¤¬ÊѤï¤Ã¤Æ¤¯¤ë¤È¤¤¤¦¤³¤È¤¬¤ï¤«¤ê¤Þ¤¹¤Í¡£
¦È¤Î³ÑÅÙ¤¬¹­¤¯¤Ê¤ë¤Û¤É¡¢½Ä¤ÎÉý¤¬Ä¹¤¯¤Ê¤ê¤Þ¤¹¡£µÕ¤Ë¡¢¦È¤Î³ÑÅÙ¤¬¶¹¤¯¤Ê¤ë¤Û¤É²£¤ÎÉý¤¬Ä¹¤¯¤Ê¤ê¤Þ¤¹¡£

¤Ä¤Þ¤ê¡¢Í×Ì󤹤ë¤È¼¡¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

¤¢¤ëÅÀ¤«¤é¡¢Ç¤°Õ¤ÎÊý¸þ¤Ø¤Î°ÜưÎ̤ò·×»»¤¹¤ë¤¿¤á¤Ë¤Ï¡¢½Ä¤Î·×»»¤Ë¤Ïsin¤ò¡¢²£¤Î·×»»¤Ë¤Ïcos¤ò»È¤¨¤Ð¤è¤¤

¤³¤ì¤Ç¤¹¡£¤³¤ì¤³¤½¤¬¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤ÎÀµÂΤǤ¹¡£

¤¢¤ëÃÏÅÀ¤«¤é¡¢Ç¤°Õ¤Î³ÑÅÙ¤ÎÊý¸þ¤Ø°Üư¤·¤¿¤¤¤È¤­¡¢¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤ò»È¤¦¤³¤È¤Ë¤è¤Ã¤Æ°Üư¤¹¤ëÎ̤òµá¤á¤ë¤³¤È¤¬¤Ç¤­¤ë¤Î¤Ç¤¹¡£Àè¤Û¤É¤Î»°³Ñ·Á¤Çɽ¤¹¤Ê¤é¡¢¦È¤ÎÉôʬ¤¬¤É¤Î¤è¤¦¤ËÊѲ½¤·¤Æ¤â¡¢¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤ò»È¤¨¤ÐÊÕA¤ÎŤµ¤ÈÊÕB¤ÎŤµ¤¬¤ï¤«¤ë¤Î¤Ç¤¹¡£¤³¤ì¤Ï¤Ä¤Þ¤ê¡¢½Ä¤Ë°Üư¤¹¤ëÎ̤Ȳ£¤Ë°Üư¤¹¤ëÎ̤¬¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤ÎÎϤǨºÂ¤Ë¤ï¤«¤ë¤È¤¤¤¦¤³¤È¤Ê¤Î¤Ç¤¹¡£¤³¤ì¤Ï¤¹¤´¤¤¡ª¡¡¡Ä¡Ä¤Ç¤¹¤è¤Í¡©

¤É¤¦¤Ç¤¹¤«¡¢¤Ê¤ó¤È¤Ê¤¯Íý²ò¤Ç¤­¤Þ¤·¤¿¤Ç¤·¤ç¤¦¤«¡©


¢£¥³¡¼¥É¤Îµ­½Ò

¤½¤ì¤Ç¤Ï¼ÂºÝ¤Ë¥³¡¼¥É¤òµ­½Ò¤·¤Þ¤·¤ç¤¦¡£
¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤ÎÀ­¼Á¤òƬ¤Ë»×¤¤ÉÁ¤­¤Ê¤¬¤é¡¢¥³¡¼¥É¤ò¸«¤Æ¹Í¤¨¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¤Í¡£

'ɸ½à¥â¥¸¥å¡¼¥ë¤Ëµ­½Ò

'APIÀë¸À
Declare Function GetTickCount Lib "kernel32" () As Long
Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMillsecounds As Long)


'±ß±¿Æ°¥×¥í¥·¡¼¥¸¥ã
Sub RollBall()
    
    Dim Radian As Single '¥é¥¸¥¢¥ó
    Dim Angle As Long 'ÅÙ¿ô
    Dim X As Single '¸¶ÅÀºÂɸ¡¡²£°ÌÃÖ
    Dim Y As Single '¸¶ÅÀºÂɸ¡¡½Ä°ÌÃÖ
    
    Dim R As Single '±ß±¿Æ°¤ÎȾ·Â
    Dim FLG As Boolean '¥ë¡¼¥×´ÉÍý¥Õ¥é¥°
    Dim C As Long '¥«¥¦¥ó¥¿¡¼¤È¤·¤Æ»È¤¦
    Dim STIME As Long 'Ʊ´ü½èÍý¤ò¹Ô¤¦¤¿¤á¤Ë»È¤¦
    
    Const PI As Single = 3.14159 '±ß¼þΨ
    
    
    X = 100 '­¡
    Y = 100
    
    R = 30 '­¢
    FLG = False
    C = 0
    
    Do Until FLG
        STIME = GetTickCount
        C = C + 5 '­£
        Angle = C Mod 360 + 1 '­¤
        Radian = Angle * PI / 180 '­¥
        With UserForm1.Image1
            .Left = X + R * Cos(Radian) '­¦
            .Top = Y + R * Sin(Radian)
            .Left = .Left - .Width / 2
            .Top = .Top - .Height / 2
        End With
        DoEvents
        Do
            Sleep 1
        Loop Until GetTickCount - STIME > 30
    Loop
    
End Sub


'¤³¤³¤«¤é²¼¤Ï¥Õ¥©¡¼¥à¥â¥¸¥å¡¼¥ë¤Ëµ­½Ò

Private Sub CommandButton1_Click()

    Call RollBall
    
End Sub


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

    End
    
End Sub

»È¤ï¤ì¤Æ¤¤¤ëÊÑ¿ô¤¬¤«¤Ê¤ê¿¤¤¤Ç¤¹¤¬¡¢ÀÖ¤¤»ú¤Ç½ñ¤«¤ì¤Æ¤¤¤ë¥³¥á¥ó¥È¤ò¤è¤¯¸«¤Æ¡¢³ÆÊÑ¿ô¤ÎÌò³ä¤ò¥¤¥á¡¼¥¸¤·¤Æ¤¯¤À¤µ¤¤¡£

¤Þ¤º¤Ï­¡¤ÎÉôʬ¤«¤é¡£
¤³¤³¤Ç¤Ï¡¢±ß¤ÎÃæ¿´¤Î°ÌÃÖ¤ò·è¤á¤Æ¤¤¤Þ¤¹¡£ X ¤Ë¤ÏÃæ¿´¤Î²£¤Î°ÌÃÖ¤¬Æþ¤ê¤Þ¤¹¡£¤½¤·¤ÆÆ±Íͤˡ¢ Y ¤Ë¤ÏÃæ¿´¤Î½Ä¤Î°ÌÃÖ¤¬Æþ¤ê¤Þ¤¹¡£

¼¡¤Ë­¢¡£¤³¤³¤Ç¤Ï¡¢±ß¤ÎȾ·Â¤ò·è¤á¤Æ¤¤¤Þ¤¹¡£º£²ó¤Ï30¤ËÀßÄꤷ¤Æ¤¤¤Þ¤¹¤¬¡¢¤³¤Î¿ôÃͤòÂ礭¤¯¤¹¤ì¤Ð±ß±¿Æ°¤Îµ°ÀפâÂ礭¤¯¤Ê¤ê¤Þ¤¹¡£µÕ¤Ë¤³¤³¤ÇÀßÄꤹ¤ë¿ôÃͤò¾®¤µ¤¯¤¹¤ì¤Ð¡¢¾®¤µ¤Ê±ß¤òÉÁ¤¯¤è¤¦¤Ë¥Ü¡¼¥ë¤¬°Üư¤¹¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

­£¤ÎÉôʬ¤Ï¡¢°ì¸«¤¹¤ë¤È²¿¤ò¤ä¤Ã¤Æ¤¤¤ë¤Î¤«¤ï¤«¤ê¤Ë¤¯¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¡£
¤³¤³¤Ç¤Ï¡¢¥«¥¦¥ó¥¿¡¼¤ÎÌò³ä¤ò²Ì¤¿¤¹¡¢ÊÑ¿ô C ¤ÎÃͤò¥ë¡¼¥×¤¹¤ë¤´¤È¤ËÁý¤ä¤·¤Æ¤¤¤Þ¤¹¡£¤½¤·¤Æ¼¡¤Î­¤¤Î¹Ô¤ò¸«¤Æ¤¯¤À¤µ¤¤¡£¤³¤³¤Ç¡¢Mod±é»»»Ò¤ò»È¤Ã¤ÆÅÙ¿ô¤ò·è¤á¤Æ¤¤¤Þ¤¹¤Í¡£

Angle = C Mod 360 + 1

Mod±é»»¤È¤Ï¡¢³ä¤ê»»¤Î;¤ê¤òµá¤á¤ë·×»»ÊýË¡¤Ç¤·¤¿¤Í¡£¤Ä¤Þ¤ê¡¢ÊÑ¿ô C ¤ÎÃͤϾï¤Ë¥ë¡¼¥×¤¹¤ë¤´¤È¤ËÁý¤¨Â³¤±¤Þ¤¹¤¬¡¢ÊÑ¿ô Angle ¤ËÆþ¤ëÃͤϡØ1¡Á360¡Ù¤Î´Ö¤Ë¤ª¤µ¤Þ¤ê³¤±¤Þ¤¹¡£
ÊÑ¿ô C ¤¬£±²ó¤Î¥ë¡¼¥×¤Ç¥×¥é¥¹¤µ¤ì¤ëÎ̤òÁý¤ä¤¹¤È¡¢·ë²ÌŪ¤Ë³ÑÅÙ¤¬Á᤯ÊѲ½¤·¤Þ¤¹¡£¤È¤¤¤¦¤³¤È¤Ï¤Ä¤Þ¤ê¡¢±ß±¿Æ°¤Î¥¹¥Ô¡¼¥É¤¬Â®¤¯¤Ê¤ê¤Þ¤¹¡£º£²ó¤Ï¡¢5ÅÙ¤º¤Äư¤«¤·¤Æ¤¤¤Þ¤¹¤¬¡¢10ÅÙ¤º¤Äư¤«¤·¤¿¤Û¤¦¤¬¥Ü¡¼¥ë¤Î°Üư¤¬Â®¤¯¤Ê¤ê¤Þ¤¹¤Í¡£

¤³¤³¤Þ¤Ç¤Çµá¤á¤¿³ÑÅÙ¤ò»È¤Ã¤Æ¡¢¥é¥¸¥¢¥ó¤òµá¤á¤Æ¤¤¤ë¤Î¤¬­¥¤Ç¤¹¤Í¡£Á°²ó¤Î¹ÖºÂ¤ÇºÜ¤»¤¿¡¢ÅÙ¿ô¤«¤é¥é¥¸¥¢¥ó¤Ø¤ÎÊÑ´¹¸ø¼°¤¬½Ð¤Æ¤­¤Æ¤¤¤Þ¤¹¡£

¤½¤·¤Æ¡¢¼ÂºÝ¤ÎºÂɸ¤ò·×»»¤·¤Æ¤¤¤ë¤Î¤¬­¦¤ÎÉôʬ¤Ç¤¹¡£

.Left = X + R * Cos(Radian)
.Top = Y + R * Sin(Radian)

Sin¤È¤¤¤¦´Ø¿ô¤È¡¢Cos¤È¤¤¤¦´Ø¿ô¤¬»È¤ï¤ì¤Æ¤¤¤Þ¤¹¡£¤³¤ì¤é¤Î´Ø¿ô¤Ë¤Ï¡¢¥é¥¸¥¢¥ó¤Ç¤Î³ÑÅÙ¤ò»ØÄꤷ¤Þ¤¹¤Î¤Ç¡¢Àè¤Û¤É·×»»¤·¤¿¥é¥¸¥¢¥ó¤ò°ú¿ô¤ËÅϤ·¤Æ¤¤¤Þ¤¹¡£

¤½¤·¤Æ¡¢ X ¤È Y ¤Ï±ß¤ÎÃæ¿´¤òɽ¤¹ºÂɸ¤Ç¤·¤¿¤Í¡£¤½¤³¤Ë¡¢¥µ¥¤¥ó¤ä¥³¥µ¥¤¥ó¤ò³Ý¤±»»¤·¤¿È¾·Â¤ò¥×¥é¥¹¤·¤Þ¤¹¡£¤³¤¦¤¹¤ë¤³¤È¤Ç¡¢ºÂɸ(X,Y)¤òÃæ¿´¤È¤·¤¿¡¢È¾·Â(R)¤Î±ß¤òÉÁ¤«¤»¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£

±ß±¿Æ°¤Î·×»»

²£°ÌÃÖ¤òµá¤á¤ë¤Ë¤Ï¡Ä¡Ä
    Ãæ¿´¤Î²£°ÌÃÖ + ±ß¤ÎȾ·Â * Cos(¥é¥¸¥¢¥ó¤Ç¤Î³ÑÅÙ)

½Ä°ÌÃÖ¤òµá¤á¤ë¤Ë¤Ï¡Ä¡Ä
    Ãæ¿´¤Î½Ä°ÌÃÖ + ±ß¤ÎȾ·Â * Sin(¥é¥¸¥¢¥ó¤Ç¤Î³ÑÅÙ)



¢£¤Þ¤È¤á

º£²ó¤Î¥µ¥ó¥×¥ë¤Ç¤Ï¡¢ÊÑ¿ô¤Ë³ÊǼ¤¹¤ë½é´üÃͤòÊѹ¹¤¹¤ë¤³¤È¤Ç¡¢ÍÍ¡¹¤ÊÂ礭¤µ¤Î±ß¤òÉÁ¤«¤»¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£

Î㤨¤Ð¡¢Ãæ¿´¤ÎºÂɸ¤òÊѹ¹¤·¤¿¤ê¡¢ÉÁ¤«¤ì¤ë±ß¤ÎÂ礭¤µ¤òÊѹ¹¤·¤¿¤ê¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£¤¤¤í¤¤¤íÃͤòÊѹ¹¤·¤Æ¼Â¹Ô¤·¤Æ¤ß¤ë¤È¡¢·ë¹½ÌÌÇò¤¤¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£

¥µ¥¤¥ó¤ä¥³¥µ¥¤¥ó¤Ï¡¢¿ô³ØÅª¤ÊÏäˤʤë¤Î¤ÇÈó¾ï¤Ë¤È¤Ã¤Ä¤­¤Ë¤¯¤¯´¶¤¸¤Þ¤¹¡£¤Ç¤¹¤¬¡¢º£²ó²òÀ⤷¤¿·×»»ÊýË¡¤µ¤¨¤ï¤«¤Ã¤Æ¤¤¤ì¤Ð¡¢¤¢¤Þ¤êÆÍ¤Ã¹þ¤ó¤À¿ô³ØÅªÃμ±¤Ï¤Ê¤¯¤Æ¤â¡¢±ß±¿Æ°¤ò½èÍý¤¹¤ë¤³¤È¤¬¤Ç¤­¤ë¤Ï¤º¤Ç¤¹¡£

Á°²ó¤Î¥é¥¸¥¢¥ó¤Ë´Ø¤¹¤ë²òÀâ¤È¡¢º£²ó¤Î¥µ¥¤¥ó¡¦¥³¥µ¥¤¥ó¤Ë´Ø¤¹¤ë²òÀâ¤òξÊýÍý²ò¤Ç¤­¤ì¤Ð¡¢¿ô³ØÅª¤Ê¤³¤È¤Ï¤è¤¯¤ï¤«¤é¤Ê¤¯¤Æ¤â¡¢¤È¤ê¤¢¤¨¤º²¿¤È¤«¤Ê¤ê¤Þ¤¹¡£¤³¤ì¤ò¤É¤¦³èÍѤ·¤Æ¤¤¤¯¤Î¤«¤Ï¡¢³§¤µ¤ó¤Î¥»¥ó¥¹¼¡Âè¤È¤¤¤¦¤³¤È¤Ë¤Ê¤ë¤Ç¤·¤ç¤¦¡£

ÊÌ´Û¤è¤ê¥µ¥ó¥×¥ë¤¬¥À¥¦¥ó¥í¡¼¥É¤Ç¤­¤Þ¤¹¤Î¤Ç¡¢¼ÂºÝ¤Ë¤É¤¦Æ°¤¯¤Î¤«¶½Ì£¤Î¤¢¤ë¿Í¤Ï¤½¤Á¤é¤ò»²¹Í¤Ë¡£


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



¢£³Ê¸À

¥µ¥¤¥ó¤È¥³¥µ¥¤¥ó¤Ï°ÕÌ£¤è¤ê¤â
»È¤¤Êý¤òÃΤ뤳¤È¤¬ÂçÀÚ


¥é¥¸¥¢¥ó¤Î¤È¤­¤â¤½¤¦¤Ç¤¹¤¬¡¢°ÕÌ£¤òÍý²ò¤¹¤ë¤è¤ê¡¢»È¤¤Êý¤ò¥Þ¥¹¥¿¡¼¤¹¤ë¤Û¤¦¤¬ÆÀ¤Ç¤¹¡£







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 ´ØÏ¢½ñÀÒ