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

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

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



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


Ads by Google

¾åµ­¤Î¹­¹ð¤Ï£±¥ö·î°Ê¾å¹¹¿·¤Î¤Ê¤¤¥Ö¥í¥°¤Ëɽ¼¨¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
¿·¤·¤¤µ­»ö¤ò½ñ¤¯»ö¤Ç¹­¹ð¤¬¾Ã¤»¤Þ¤¹¡£






£Ã£è£á£ð£ô£å£ò.£±£±£µ [ ¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à£±£°¡§¥Ü¡¼¥ë¤Î½èÍý ]

¢£¥Ü¡¼¥ë¤Î½èÍý¤ËÁȤ߹þ¤à

Á°²ó¤ÈÁ°¡¹²ó¡¢¤Á¤ç¤Ã¤È¿ô³ØÅª¤ÊÏä¬Â³¤­¤Þ¤·¤¿¡£¾¯¤·Æñ²ò¤ÊÆâÍÆ¤Ç¤Ï¤¢¤ê¤Þ¤·¤¿¤¬¡¢Âç»ö¤Ê¤Î¤Ï¤½¤ì¤ò¥×¥í¥°¥é¥à¤Ë¤É¤¦³èÍѤ¹¤ë¤«¤Ç¤¹¡£º£²ó¤Ï¡¢Á°²ó¤Þ¤Ç¤ÇºîÀ®¤·¤¿Àþʬ¤¬´Ø·¸¤¹¤ë½èÍý¤ò¡¢¤½¤ì¤¾¤ì¥Ü¡¼¥ë¤Î½èÍý¤ËÁȤ߹þ¤ó¤Ç¤¤¤­¤Þ¤¹¡£

º£²óºîÀ®¤¹¤ë¥Ü¡¼¥ë¤Î½èÍý¤Ï¡¢¤«¤Ê¤êµ¬ÌϤÎÂ礭¤Ê¥×¥í¥·¡¼¥¸¥ã¤Ë¤Ê¤ê¤Þ¤¹¡£¥Ý¥¤¥ó¥È¤È¤·¤Æ¤Ï¡¢Á°²ó¤Þ¤Ç¤ËºîÀ®¤·¤Æ¤¤¤ëÀþʬ´Ø·¸¤Î½èÍý¤¬¡¢¤½¤ì¤¾¤ì¤É¤Î¤è¤¦¤Ê°ÕÌ£¤Î¥×¥í¥·¡¼¥¸¥ã¤Ê¤Î¤«¡¢¤½¤ì¤ò¤è¤¯Íý²ò¤·¤ÆºîÀ®¤·¤Æ¤¤¤¯¤³¤È¤Ç¤¹¡£¥Ü¡¼¥ë½èÍý¤ÎÍÍ¡¹¤Ê¤È¤³¤í¤ÇÅо줷¤Þ¤¹¤Î¤Ç¡¢¤½¤ÎÅÔÅ٤ɤ¦¤¤¤¦°ÕÌ£¹ç¤¤¤Ç¥×¥í¥·¡¼¥¸¥ã¤¬¸Æ¤Ó½Ð¤µ¤ì¤Æ¤¤¤ë¤Î¤«¤òÍý²ò¤·¤Æ¤¤¤Ê¤¤¤È¡¢¤ï¤±¤¬¤ï¤«¤é¤Ê¤¯¤Ê¤ë¤È»×¤¤¤Þ¤¹¡£

Á°¤â¤Ã¤Æ¡¢ºÆÅÙÁ°²ó¤Þ¤Ç¤ËºîÀ®¤·¤Æ¤¤¤ë¥×¥í¥·¡¼¥¸¥ã¤ò³Îǧ¤·¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£

CrossLine ¡Ä¡Ä Àþʬ¤Î¸òº¹¤òȽÄꤷBool·¿¤Ç·ë²Ì¤òÊÖ¤¹
CrossPoint ¡Ä¡Ä Àþʬ¤Î¸òÅÀ¤òVector·¿¤ÇÊÖ¤¹

¤³¤ì¤¬Á°²ó¤Þ¤Ç¤ËºîÀ®¤·¤¿¤Õ¤¿¤Ä¤Î¥×¥í¥·¡¼¥¸¥ã¤Ç¤·¤¿¤Í¡£¸òº¹¤òȽÄꤹ¤ë CrossLine ¤È¡¢¸òÅÀ¤ÎºÂɸ¤ò»»½Ð¤¹¤ë CrossPoint ¤Î¤Õ¤¿¤Ä¤ò³èÍѤ·¤Ê¤¬¤é¡¢¥Ö¥í¥Ã¥¯Êø¤·¤Î³Ë¤È¤Ê¤ë¥Ü¡¼¥ë¤Î½èÍý¤òºîÀ®¤·¤Æ¤¤¤­¤Þ¤¹¡£CrossPoint ¤Î¤Û¤¦¤Ï¡¢¥æ¡¼¥¶¡¼ÄêµÁ·¿¤Ç¤¢¤ë Vector ·¿¤Ç·ë²Ì¤òÊÖ¤·¤Æ¤­¤Þ¤¹¤Î¤Ç¡¢Ãí°Õ¤·¤Þ¤·¤ç¤¦¡£


¢£¥Ü¡¼¥ë½èÍý¤Î³µÍ×

¤µ¤Æ¡¢¤½¤ì¤Ç¤Ï¥Ü¡¼¥ë½èÍý¤ò¼ÂºÝ¤Ë¸«¤Æ¤¤¤­¤Þ¤¹¡£

¥Ü¡¼¥ë¤ò½èÍý¤¹¤ëºÝ¤Ï¡¢É¬ÍפʾðÊó¤ò¤Ò¤È¤Ä¤Ò¤È¤Ä¼èÆÀ¤·¤Ê¤¬¤é¡¢ÍÍ¡¹¤Ê¥±¡¼¥¹¤òÁÛÄꤷ¤Æ½èÍý¤òÁȤó¤Ç¤¤¤­¤Þ¤¹¡£¤ª¤ª¤Þ¤«¤Ê¼ê½ç¤Ç¸À¤¦¤È¡¢¤Þ¤º¤Ï¥Ü¡¼¥ë¤Î¸½ºß¤ÎºÂɸ(°Üư¤¹¤ëÁ°¤Î°ÌÃÖ)¤È¡¢°Üư¤·¤¿¤¢¤È¤ÎºÂɸ¤òÌÀ³Î¤Ë¤·¤Þ¤¹¡£¤³¤³¤Þ¤Ç¤Ï¡¢¤É¤ó¤Ê¾ì¹ç¤Ç¤âɬ¤ºÆ±¤¸¤è¤¦¤Ë¹Ô¤¦É¬Íפ¬¤¢¤ê¤Þ¤¹¤Í¡£

°Üư¸å¤ÎºÂɸ¤¬ÌÀ³Î¤Ë¤Ê¤ë¤È¡¢º£Å٤Ϥ½¤³¤ËÊɤä¥Ö¥í¥Ã¥¯¤¬Â¸ºß¤¹¤ë¤Î¤«¤É¤¦¤«¤òȽÃǤ·¤Þ¤¹¡£¤â¤·¡¢Êɤä¥Ö¥í¥Ã¥¯¤¬¤½¤³¤Ë¤¢¤Ã¤Æ¡¢¥Ü¡¼¥ë¤òÈ¿¼Í¤µ¤»¤ëɬÍפ¬¤¢¤ë¤Ê¤é¡¢¥Ü¡¼¥ë¤Î°Üư¤¹¤ë¸þ¤­¤òȿž¤µ¤»¤¿¤ê¤·¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¤Í¡£

¤³¤Î¤è¤¦¤Ë¹Í¤¨¤ë¤È¡¢¥Ü¡¼¥ë¤Î½èÍý¤Î¤ª¤ª¤Þ¤«¤Êή¤ì¤Ï¼¡¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

¥Ü¡¼¥ë¤Î¸½ºß°ÌÃÖ¤È°ÜÆ°¸å¤Î°ÌÃÖ¤òÌÀ³Î¤Ë¤¹¤ë
    ¢§
¤½¤³¤ËÊɤ¬¤¢¤ë¤«¤òÄ´¤Ù¤ë
    ¢§
Êɤ¬¤¢¤ë¤Ê¤é¥Ü¡¼¥ë¤Î°ÜưÊý¸þ¤òȿž¤¹¤ë
    ¢§
¥Ü¡¼¥ë¤¬²èÌ̾å¤Î¾åȾʬ¤Ë¤¢¤ë¤«²¼È¾Ê¬¤Ë¤¢¤ë¤«Ä´¤Ù¤ë
    ¢§
¾åȾʬ¤Ë¤¢¤ë¤Ê¤é¥Ö¥í¥Ã¥¯¤È¾×ÆÍ¤·¤Æ¤¤¤ë¤«¤â¤·¤ì¤Ê¤¤
    ¢§
¥Ö¥í¥Ã¥¯¤È¤Î¾×ÆÍ¤¬¤¢¤ë¤Î¤«¤É¤¦¤«Ä´¤Ù¤ë
    ¢§
¥Ö¥í¥Ã¥¯¤È¾×ÆÍ¤·¤Æ¤¤¤ë¤Ê¤é¥Ü¡¼¥ë¤Î°ÜưÊý¸þ¤òȿž¤¹¤ë
    ¢§
²¼È¾Ê¬¤Ë¤¢¤ë¤Ê¤é¥Ð¡¼¤È¾×ÆÍ¤·¤Æ¤¤¤ë¤«¤â¤·¤ì¤Ê¤¤
    ¢§
¥Ð¡¼¤È¤Î¾×ÆÍ¤¬¤¢¤ë¤Î¤«¤É¤¦¤«Ä´¤Ù¤ë
    ¢§
¥Ð¡¼¤È¾×ÆÍ¤·¤Æ¤¤¤ë¤Ê¤é¥Ü¡¼¥ë¤Î°ÜưÊý¸þ¤òȿž¤¹¤ë
    ¢§
ºÇ½ªÅª¤Ë¥Ü¡¼¥ë¤¬¤É¤³¤ËÃÖ¤«¤ì¤ë¤Î¤«·èÄꤹ¤ë

¤³¤ó¤Ê´¶¤¸¤Ë¤Ê¤ê¤Þ¤¹¤Í¡£


¢£¥Ü¡¼¥ë¤Î½èÍý

¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤ÏÂçÊ̤·¤Æ¤ß¤Ã¤Ä¤Î¥Ö¥í¥Ã¥¯¤«¤éÀ®¤êΩ¤Ã¤Æ¤¤¤Þ¤¹¡£¤½¤ì¤¾¤ì¤Î¥Ö¥í¥Ã¥¯¤ÎÌò³ä¤ò¤·¤Ã¤«¤êÍý²ò¤·¤Æ¤¤¤¯¤³¤È¤¬ÂçÀڤǤ¹¡£

³Æ¥Ö¥í¥Ã¥¯¤Ï¥³¡¼¥É¤ò¿§Ê¬¤±¤·¤ÆÉ½¼¨¤·¤Æ¤¤¤Þ¤¹¡£¤½¤ì¤ò»²¹Í¤Ë¤·¤Ê¤¬¤é¹Í¤¨¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£

Sub Ball_Move()

    Dim L As Long
    Dim S As Single
    Dim SS As Single

    Dim fX As Boolean
    '²£Êý¸þ¤Ç¤Î¾×ÆÍ¤¬¤¢¤Ã¤¿¤«¤É¤¦¤«¤òÊÝ»ý¤¹¤ë¥Õ¥é¥°

    Dim fY As Boolean
    '½ÄÊý¸þ¤Ç¤Î¾×ÆÍ¤¬¤¢¤Ã¤¿¤«¤É¤¦¤«¤òÊÝ»ý¤¹¤ë¥Õ¥é¥°

    Dim oX As Single
    'Àþʬ¤Î½èÍý¤ËÍøÍѤ¹¤ëXºÂɸ

    Dim oY As Single
    'Àþʬ¤Î½èÍý¤ËÍøÍѤ¹¤ëYºÂɸ

    Dim CP As Vector
    'Àþʬ¤Î¸òÅÀºÂɸ¤òÊÝ»ý¤¹¤ë¤¿¤á¤ÎVector·¿ÊÑ¿ô
    
    With Ball
        fX = False '¥Õ¥é¥°¤ò½é´ü²½¤¹¤ë
        fY = False '¥Õ¥é¥°¤ò½é´ü²½¤¹¤ë
        .aX = .bX + .vX * .Sp '°Üư¸å¤Î¥Ü¡¼¥ë¤ÎXºÂɸ¤òµá¤á¤ë
        .aY = .bY + .vY * .Sp '°Üư¸å¤Î¥Ü¡¼¥ë¤ÎYºÂɸ¤òµá¤á¤ë
        CP.X = .aX
        CP.Y = .aY
        If .aX < W_Ball / 2 Then
            fX = True
            CP = CrossPoint(.aX, .aY, _
                            .bX, .bY, _
                            W_Ball / 2, 0, _
                            W_Ball / 2, H_Field)
        End If
        If .aX > W_Field - W_Ball / 2 Then
            fX = True
            CP = CrossPoint(.aX, .aY, _
                            .bX, .bY, _
                            W_Field - W_Ball / 2, 0, _
                            W_Field - W_Ball / 2, H_Field)
        End If
        If .aY < W_Ball / 2 Then
            fY = True
            CP = CrossPoint(.aX, .aY, _
                            .bX, .bY, _
                            0, W_Ball / 2, _
                            W_Field, W_Ball / 2)
        End If
        If .aY > H_Field Then
            .Vis = False
        End If

        If .aY <= H_Field / 2 Then
            For L = 1 To 25
                If Block(L).Vis Then
                    If Not fX Then
                        SS = W_Ball / 2
                        fX = False
                        If .vX < 0 Then
                            S = Block(L).X + W_Block / 2
                            oX = S + SS
                        Else
                            S = Block(L).X - W_Block / 2
                            oX = S - SS
                        End If
                        fX = CrossLine(.aX, .aY, _
                                       .bX, .bY, _
                                       oX, Block(L).Y - H_Block / 2 - SS, _
                                       oX, Block(L).Y + H_Block / 2 + SS)
                        If fX Then
                            CP = CrossPoint(.aX, .aY, _
                                            .bX, .bY, _
                                            oX, Block(L).Y - H_Block / 2 - SS, _
                                            oX, Block(L).Y + H_Block / 2 + SS)
                            Block(L).Vis = False
                            If .Sp < 12.5 Then .Sp = .Sp + 0.5
                        End If
                    End If
                    If Not fY Then
                        SS = W_Ball / 2
                        fY = False
                        If .vY < 0 Then
                            S = Block(L).Y + H_Block / 2
                            oY = S + SS
                        Else
                            S = Block(L).Y - H_Block / 2
                            oY = S - SS
                        End If
                        fY = CrossLine(.aX, .aY, _
                                       .bX, .bY, _
                                       Block(L).X - W_Block / 2 - SS, oY, _
                                       Block(L).X + W_Block / 2 + SS, oY)
                        If fY Then
                            CP = CrossPoint(.aX, .aY, _
                                            .bX, .bY, _
                                            Block(L).X - W_Block / 2 - SS, oY, _
                                            Block(L).X + W_Block / 2 + SS, oY)
                            Block(L).Vis = False
                            If .Sp < 12.5 Then .Sp = .Sp + 0.5
                        End If
                    End If
                End If
                UserForm1.Controls("Label" & L).Visible = Block(L).Vis
            Next
            If fX Then
                .vX = -.vX
                .aX = CP.X
                .aY = CP.Y
            End If
            If fY Then
                .vY = -.vY
                .aX = CP.X
                .aY = CP.Y
            End If

        Else
            If .vY > 0 Then
                If Not fX And Not fY Then
                    SS = W_Ball / 2
                    fX = False
                    If .vX < 0 Then
                        S = Bar.X + W_Bar / 2
                        oX = S + SS
                    Else
                        S = Bar.X - W_Bar / 2
                        oX = S - SS
                    End If
                    fX = CrossLine(.aX, .aY, _
                                   .bX, .bY, _
                                   oX, Bar.Y - H_Bar / 2 - SS, _
                                   oX, Bar.Y + H_Bar / 2 + SS)
                    If fX Then
                        CP = CrossPoint(.aX, .aY, _
                                        .bX, .bY, _
                                        oX, Bar.Y - H_Bar / 2 - SS, _
                                        oX, Bar.Y + H_Bar / 2 + SS)
                    End If
                    fY = False
                    S = Bar.Y - H_Bar / 2
                    oY = S - SS
                    fY = CrossLine(.aX, .aY, _
                                   .bX, .bY, _
                                   Bar.X - W_Bar / 2 - SS, oY, _
                                   Bar.X + W_Bar / 2 + SS, oY)
                    If fY Then
                        CP = CrossPoint(.aX, .aY, _
                                        .bX, .bY, _
                                        Bar.X - W_Bar / 2 - SS, oY, _
                                        Bar.X + W_Bar / 2 + SS, oY)
                    End If
                End If
            End If
            If fX Then
                .vX = -.vX
                .aX = CP.X
                .aY = CP.Y
            End If
            If fY Then
                .vY = -.vY
                .aX = CP.X
                .aY = CP.Y
                S = Bar.X - W_Bar / 2
                SS = Bar.X + W_Bar / 2
                If .aX >= S Then
                    If .aX <= S + (W_Bar / 3) Then .vX = -Abs(.vX)
                End If
                If .aX <= SS Then
                    If .aX >= SS - (W_Bar / 3) Then .vX = Abs(.vX)
                End If
                If .aX > S + (W_Bar / 3) Then
                    If .aX < SS - (W_Bar / 3) Then .vY = -Abs(.vY) * 1.05
                End If
            End If

        End If
        If .aX < W_Ball / 2 Then .aX = W_Ball / 2
        If .aX > W_Field - W_Ball / 2 Then .aX = W_Field - W_Ball / 2
        If .aY < W_Ball / 2 Then .aY = W_Ball / 2
        .bX = .aX
        .bY = .aY
    End With
    
    With UserForm1
        .Ima_ball.Left = Ball.aX - W_Ball / 2
        .Ima_ball.Top = Ball.aY - W_Ball / 2
    End With
    
End Sub

¤È¤Æ¤âŤ¤¥×¥í¥·¡¼¥¸¥ã¤Ç¤¹¤Í¡£
¤Á¤ç¤Ã¤Èµ¤¤¬¤á¤¤¤ê¤½¤¦¤Ë¤Ê¤ê¤Þ¤¹¤¬¡¢½çÈ֤˸«¤Æ¤¤¤­¤Þ¤·¤ç¤¦¡£

¤Þ¤º¡¢ºÇ½é¤Î²«¿§¤¤Ê¸»ú¤ÎÉôʬ¤Ç¤Ï¡¢ÊÉ¤È¤Î¾×ÆÍ¤¬¤¢¤Ã¤¿¤Î¤«¤É¤¦¤«¤òÄ´¤Ù¤Æ¤¤¤Þ¤¹¡£¤¢¤é¤«¤¸¤áÀë¸À¤·¤Æ¤¢¤Ã¤¿Äê¿ô¤ò¤¦¤Þ¤¯¤Ä¤«¤Ã¤Æ¡¢¥Ü¡¼¥ë¤È¡¢º¸¡¦¾å¡¦±¦¤ÎÊÉ¤È¤Î¾×ÆÍ¤¬¤¢¤Ã¤¿¤Î¤«¤É¤¦¤«¤òȽÄꤷ¤Æ¤¤¤Þ¤¹¡£

Êɤθþ¤³¤¦Â¦¤Ë¤á¤ê¤³¤ó¤Ç¤·¤Þ¤¦¤è¤¦¤ÊºÂɸ¤Ë¥Ü¡¼¥ë¤¬Åþ㤷¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢¤³¤ì¤Ï¾×ÆÍ¤ò¤·¤Æ¤¤¤ë¤³¤È¤ÈƱ¤¸¤Ç¤¹¡£¥Ü¡¼¥ë¤Î°ÜưÁ°¤ÎºÂɸ¤È¡¢°Üư¸å¤ÎºÂɸ¤ò¤Ä¤Ê¤¤¤Ç°ìËܤÎÀþʬ¤òºî¤ê¡¢¤µ¤é¤Ë¡¢Êɤò°ìËܤÎÀþʬ¤È¹Í¤¨¤Æ¡¢ÀþʬƱ»Î¤Î¸òº¹È½Äê¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¤Í¡£(¥×¥í¥·¡¼¥¸¥ã CrossPoint ¤ò¸Æ¤Ó½Ð¤·¤Æ¤¤¤ëÉôʬ)

ÊÑ¿ô CP ¤Ï¡¢Vector ·¿¤ÎÊÑ¿ô¤Ç¤¹¡£¤Ç¤¹¤«¤é¡¢¥×¥í¥·¡¼¥¸¥ã CrossPoint ¤¬ÊÖ¤·¤Æ¤¯¤ë¸òÅÀºÂɸ¤Î¾ðÊó¤ò¼õ¤±¼è¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£CrossPoint ¤ò¸Æ¤Ó½Ð¤·¤¿¤¢¤È¡¢ÊÑ¿ô CP ¤Ë¼èÆÀ¤µ¤ì¤Æ¤¤¤ëºÂɸ¾ðÊó¤òÄ´¤Ù¤ì¤Ð¡¢¥Ü¡¼¥ë¤¬Â¸ºß¤¹¤ë¤Ù¤­ºÂɸ¤¬¤ï¤«¤ë¤È¤¤¤¦¤ï¤±¤Ç¤¹¡£

¤â¤·¡¢²¼¤ÎÊɤè¤ê¤â¥Ü¡¼¥ë¤¬¸þ¤³¤¦Â¦¤Ë¤¢¤ë¾ì¹ç¤Ï¡¢¤³¤ì¤Ï¥Ü¡¼¥ë¤òÍî¤È¤·¤Æ¤·¤Þ¤Ã¤Æ¤¤¤ë¤È¤¤¤¦¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¤Í¡£¤Ç¤¹¤«¤é¤³¤Î¾ì¹ç¤Ï¡¢¥Ü¡¼¥ë¤ò¸«¤¨¤Ê¤¤¤è¤¦¤Ë¤·¤Æ¤¤¤Þ¤¹¡£
¤³¤ì¤Ç¡¢¥Ü¡¼¥ë¤ÈÊɤȤνèÍý¤Ï¤¹¤Ù¤Æ´°Î»¤Ç¤¹¡£


³¤¤¤Æ¡¢¥Ü¡¼¥ë¤¬²èÌ̾å¤Î¾åȾʬ¤Ë¤¤¤ë¤Î¤«¡¢¤½¤ì¤È¤â²¼È¾Ê¬¤Ë¤¤¤ë¤Î¤«¤òÄ´¤Ù¡¢¤½¤Î·ë²Ì¤Ë¤è¤Ã¤Æ½èÍý¤òʬ³ä¤·¤Æ¤¤¤Þ¤¹¡£

¥Ü¡¼¥ë¤¬¾åȾʬ¤Ë¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢¥Ö¥í¥Ã¥¯¤È¾×ÆÍ¤ò¤·¤Æ¤¤¤ë²ÄǽÀ­¤¬¤¢¤ë¤¿¤á¡¢¥Ö¥í¥Ã¥¯¤È¤Î¾×ÆÍ¤¬¤¢¤ë¤Î¤«¤É¤¦¤«¤òÄ´¤Ù¤Æ¤¤¤­¤Þ¤¹¡£¤³¤ì¤¬Î理Îʸ»ú¤Ç½ñ¤«¤ì¤Æ¤¤¤ë¥³¡¼¥É¤ÎÉôʬ¤Ç¤¹¤Í¡£

¥Ö¥í¥Ã¥¯¤Ò¤È¤Ä¤Ò¤È¤Ä¤È½çÈÖ¤Ë¾×ÆÍȽÄê¤ò¹Ô¤Ã¤Æ¤¤¤­¡¢¤â¤·¾×ÆÍ¤¬È¯À¸¤·¤Æ¤¤¤ë¤Ê¤éÊɤΤȤ­¤ÈƱÍͤËÀþʬ¤Ë¤è¤ë½èÍý¤ò¹Ô¤¤¤Þ¤¹¡£ºÇ½ªÅª¤ËÀþʬƱ»Î¤Î¸òÅÀºÂɸ¤ò»»½Ð¤·¤Æ¡¢¤½¤ì¤ò¥Ü¡¼¥ë¤ÎºÇ½ªÅª¤Ê°Üư¸å¤Î°ÌÃ֤Ȥ·¤ÆÀßÄꤹ¤ë¤ï¤±¤Ç¤¹¡£

¥Ü¡¼¥ë¤¬²¼È¾Ê¬¤Ë¤¤¤ë¾ì¹ç¤Ï¡¢¥Ö¥í¥Ã¥¯¤È¾×ÆÍ¤¹¤ë²ÄǽÀ­¤Ï¤¢¤ê¤Þ¤»¤ó¡£¤½¤ÎÂå¤ï¤ê¡¢¥Ð¡¼¤È¤Î¾×ÆÍ¤¬È¯À¸¤·¤Æ¤¤¤ë²ÄǽÀ­¤Ï¤¢¤ê¤Þ¤¹¤Í¡£¥Ð¡¼¤È¤Î¾×ÆÍȽÄê¤ò¹Ô¤Ã¤Æ¤¤¤ë¤Î¤Ï¿å¿§¤Îʸ»ú¤Ç¼¨¤µ¤ì¤Æ¤¤¤ëÉôʬ¤Ç¤¹¡£
¤³¤³¤Ç¤â¡¢¥Ö¥í¥Ã¥¯¤È¥Ü¡¼¥ë¤Î¤È¤­¤Ë¹Ô¤Ã¤¿¤Î¤ÈƱÍͤˡ¢¥Ð¡¼¤È¥Ü¡¼¥ë¤Î¾×ÆÍȽÄê¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¡£¤â¤·¥Ð¡¼¤È¥Ü¡¼¥ë¤¬¾×ÆÍ¤·¤Æ¤¤¤ë¤Î¤Ê¤é¡¢Àþʬ¤Ë¤è¤ë¾×ÆÍȽÄê¤ò¹Ô¤Ã¤Æ¥Ü¡¼¥ë¤ÎºÇ½ªÅª¤Ê°ÌÃÖ¤ò»»½Ð¤·¤Æ¤¤¤Þ¤¹¡£


¤É¤Î¤è¤¦¤Ê¾×ÆÍȽÄê¤Î¾ì¹ç¤Ç¤â¡¢¤Þ¤º¤Ï¥×¥í¥·¡¼¥¸¥ã CrossLine ¤ò»È¤Ã¤Æ¡¢Àþʬ¤Î¸òº¹¤¬¤¢¤ë¤Î¤«¤É¤¦¤«¤òȽÄꤷ¤Æ¤¤¤Þ¤¹¡£¥Ü¡¼¥ë¤Î°ÜưÁ°¤ÎºÂɸ¤È¡¢°Üư¸å¤ÎºÂɸ¤ò·Ò¤¤¤Ç°ìËܤÎÀþʬ¤òºî¤ê¡¢ÂоݤȤʤë¥Ö¥í¥Ã¥¯¤ä¥Ð¡¼¤Î°ìÊÕ¤òÀþʬ¤È¤·¤Æ¹Í¤¨¡¢¤³¤ì¤éÆóËܤÎÀþʬ¤Î¸òº¹¤òȽÄꤷ¤Þ¤¹¡£
ÀþʬƱ»Î¤¬¸òº¹¤·¤Æ¤¤¤ë¤Ê¤é¡¢¤³¤ì¤Ï¾×ÆÍ¤¬µ¯¤³¤Ã¤Æ¤¤¤ë¤³¤È¤ÈƱ¤¸¤Ë¤Ê¤ê¤Þ¤¹¡£¾×ÆÍ¤¬µ¯¤³¤Ã¤Æ¤¤¤ë¤Ê¤é¡¢º£ÅÙ¤ÏÀþʬ¤ÈÀþʬ¤È¤Î¸òÅÀ¤ò»»½Ð¤¹¤ë¤¿¤á¤Ë CrossPoint ¤ò¸Æ¤Ó½Ð¤·¡¢¸òÅÀºÂɸ¤Ë¥Ü¡¼¥ë¤òÇÛÃÖ¤¹¤ë¤³¤È¤Ç¡¢¥Ü¡¼¥ë¤ÎºÇ½ªÅª¤ÊºÂɸ°ÌÃÖ¤ò·èÄꤷ¤Æ¤¤¤Þ¤¹¡£


¢£¤Þ¤È¤á

¤µ¤Æ¡¢¤Ï¤¿¤·¤Æ¤³¤Î²òÀâ¤ò¸«¤Æ¤¤¤ë¿Í¤¬¡¢¤³¤ÎÀâÌÀ¤À¤±¤Ç¤É¤ì¤À¤±Íý²ò¤Ç¤­¤Æ¤¤¤ë¤Î¤«É԰¤Ǥ¹¤¬¡¢¤¤¤«¤¬¤Ç¤·¤ç¤¦¤«¡£¥×¥í¥·¡¼¥¸¥ã¼«ÂΤ¬¤«¤Ê¤êÂ礭¤¤¤Î¤Ç¡¢¤Á¤ç¤Ã¤ÈÍý²ò¤¹¤ë¤Î¤¬ÂçÊѤ«¤â¤·¤ì¤Þ¤»¤ó¡£

¥Ý¥¤¥ó¥È¤È¤Ê¤ë¤Î¤Ï¡¢¥³¡¼¥É¤Ë¤Ä¤±¤é¤ì¤¿¿§¤ò»²¹Í¤Ë¤·¤Æ¡¢¤½¤ÎÉôʬ¤¬°ìÂΤɤΤ褦¤Ê½èÍý¤ò¹Ô¤Ã¤Æ¤¤¤ëÉôʬ¤Ê¤Î¤«¤ò¤·¤Ã¤«¤êÍý²ò¤·¤Æ¹Í¤¨¤ë¤³¤È¤Ç¤¹¡£
º£¸½ºß¤Ï¡¢¥Ü¡¼¥ë¤È²¿¤È¤Î¾×ÆÍ¤òȽÄꤷ¤Æ¤¤¤ëÉôʬ¤Ê¤Î¤«¡¢¤½¤ì¤¬ÌÀ³Î¤Ë¤Ê¤Ã¤Æ¤¤¤Ê¤¤¤È¤Ê¤«¤Ê¤«¥¹¥à¡¼¥º¤ËÍý²ò¤¹¤ë¤³¤È¤ÏÆñ¤·¤¤¤Ç¤·¤ç¤¦¡£ÊÉ¡¢¥Ö¥í¥Ã¥¯¡¢¥Ð¡¼¡¢¤½¤·¤Æ¥Ü¡¼¥ë¡£¤³¤ì¤é¤¬¤É¤Î¤è¤¦¤Ê´Ø·¸¤Ë¤¢¤ë¤Î¤«¤ò¤·¤Ã¤«¤êÍý²ò¤·¤Æ½èÍý¤ò¹Í¤¨¤Þ¤·¤ç¤¦¡£

¼ÂºÝ¤Ëư¤¯¥µ¥ó¥×¥ë¤Ï¡¢¼¡²ó¡¢¥À¥¦¥ó¥í¡¼¥É¤Ç¤­¤ë¤è¤¦¤Ë¤¹¤ë¤Ä¤â¤ê¤Ç¤¹¡£
¤½¤·¤Æ¡¢¼¡²ó¤Ï¶²¤é¤¯¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à¤ÎºÇ½ª²ó¤Ë¤Ê¤ë¤È»×¤¤¤Þ¤¹¡£´°À®¤·¤¿¥Ö¥í¥Ã¥¯Êø¤·¥²¡¼¥à¤Î¥µ¥ó¥×¥ë¤Ï¡¢¤½¤Î¤È¤­¤Ë¤ªÈäϪÌܤ·¤Þ¤¹¡£



¢£³Ê¸À

¸½ºß¤Î¾õÂÖ¤òÇİ®¤·¤Æ½èÍý¤¹¤ë
Àþʬ´ØÏ¢¤Î½èÍý¤Î°ÕÌ£¤òÍý²ò¤¹¤ë


Á°²ó¤Þ¤Ç¤Î¾åÀѤߤ¬¡¢¤³¤³¤Ø¤­¤Æ½ÅÍפˤʤê¤Þ¤¹¡£
°ÕÌ£¤¬¤ï¤«¤é¤Ê¤¤¾ì¹ç¤Ï¾¯¤·Ìá¤Ã¤Æ¡¢¤â¤¦°ìÅٹͤ¨¤Æ¤ß¤ë¤Î¤â¤¤¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¡£







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


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




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

By FC2¥Ö¥í¥°

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

Powered By FC2¥Ö¥í¥°

Counter

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

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

edita


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


VBA ´ØÏ¢½ñÀÒ