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

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

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



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


£Ã£è£á£ð£ô£å£ò.£¶£± [ ¥«¡¼¥É¥²¡¼¥à¤Ç»È¤¨¤ë¤á¤¯¤ê¸ú²Ì ]

¢£¥×¥í¥Ñ¥Æ¥£¤ò³èÍѤ·¤¿±é½Ð

¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤ËÇÛÃ֤Ǥ­¤ëÍÍ¡¹¤Ê¥³¥ó¥È¥í¡¼¥ë¤¿¤Á¡£¤½¤ì¤é¤Î¿¤¯¤Ï¡¢Èó¾ï¤Ë¿ºÌ¤Ê¥×¥í¥Ñ¥Æ¥£¤ò»ý¤Ã¤Æ¤¤¤Þ¤¹¡£¤³¤ì¤é¤Î¥×¥í¥Ñ¥Æ¥£¤òÊѲ½¤µ¤»¤ë¤³¤È¤Ç¡¢¥æ¡¼¥¶¡¼¤Ë¤È¤Ã¤Æ°·¤¤¤ä¤¹¤¤¥¤¥ó¥¿¡¼¥Õ¥§¥¤¥¹¤òºî¤Ã¤¿¤ê¡¢°ÂÄꤷ¤¿¥×¥í¥°¥é¥à¤òºîÀ®¤¹¤ë¤³¤È¤¬¤Ç¤­¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

¤Ç¤¹¤¬¡¢¥×¥í¥Ñ¥Æ¥£¤ò³èÍѤ¹¤ë¤³¤È¤Ç¡¢¥²¡¼¥à¤Î±é½ÐÌ̤¬¶¯²½¤µ¤ì¤ë¾ì¹ç¤â¤¢¤ê¤Þ¤¹¡£

º£¤Þ¤Ç°·¤Ã¤Æ¤­¤¿¡¢¥¢¥Ë¥á¡¼¥·¥ç¥ó½èÍý¤ä¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤Î½èÍý¤Ç¤â¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ÎBackStyle¥×¥í¥Ñ¥Æ¥£¤ò¤¦¤Þ¤¯ÍøÍѤ·¤¿¥­¥ã¥é¥¯¥¿¡¼¤Îɽ¼¨¤Ê¤É¤ò¹Ô¤Ã¤Æ¤­¤Þ¤·¤¿¤Í¡£
¤³¤ì¤â¡¢¥×¥í¥Ñ¥Æ¥£¤ÎÀ®¤»¤ëµ»¤Ç¤¹¡£

º£²ó¤Ï¡¢¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤¬»ý¤Ã¤Æ¤¤¤ë¥×¥í¥Ñ¥Æ¥£¤Î¤¦¤Á¡¢PictureSizeMode¤È¤¤¤¦¥×¥í¥Ñ¥Æ¥£¤Ë¥Õ¥©¡¼¥«¥¹¤òÅö¤Æ¤Æ¤ß¤¿¤¤¤È»×¤¤¤Þ¤¹¡£


¢£PictureSizeMode¥×¥í¥Ñ¥Æ¥£

¥³¥ó¥È¥í¡¼¥ë¤Ë²èÁü¤òɽ¼¨¤¹¤ëºÝ¡¢¤½¤Îɽ¼¨ÊýË¡¤ËPictureSizeMode¤¬±Æ¶Á¤òÍ¿¤¨¤Þ¤¹¡£
PictureSizeMode¤Ï¡¢²èÁü¤ÎÂ礭¤µ¤È¥³¥ó¥È¥í¡¼¥ë¤ÎÂ礭¤µ¤¬°ìÃפ·¤Æ¤¤¤Ê¤¤¾ì¹ç¤Ë¡¢²èÁü¤ò¿­½Ì¤µ¤»¤ÆÉ½¼¨¤µ¤»¤ë¤«¡¢¤¢¤ë¤¤¤Ï¤½¤Î¤Þ¤Þ¤ÎÂ礭¤µ¤ò°Ý»ý¤·¤ÆÉ½¼¨¤µ¤»¤ë¤«¡¢¤½¤ì¤ò´ÉÍý¤·¤Þ¤¹¡£
¥·¥å¡¼¥Æ¥£¥ó¥°¥²¡¼¥à¤ÎÃæ¤Ç¤â¡¢¤³¤Î¥×¥í¥Ñ¥Æ¥£¤ò»È¤Ã¤¿Éôʬ¤¬¤¢¤ê¤Þ¤·¤¿¤Í(Chapter54¤ò»²¾È)¡£

¤³¤Î¥×¥í¥Ñ¥Æ¥£¤ò¤¦¤Þ¤¯³èÍѤ¹¤ë¤³¤È¤Ç¡¢¥«¡¼¥É¤¬¤á¤¯¤ì¤ë¤è¤¦¤Ê±é½Ð¤ò¹Ô¤¦¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£Áᮡ¢¤½¤Î¾ÜºÙ¤ò¸«¤Æ¤ß¤Þ¤·¤ç¤¦¡£

¤Þ¤º¤Ï¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Ë¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ò£³¤ÄÇÛÃÖ¤·¤Þ¤¹¡£¤³¤Î¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤¬¥«¡¼¥É¤ÎÌò³ä¤ò²Ì¤¿¤·¤Þ¤¹¡£
¤³¤Î¤¦¤Á¡¢£±¤Ä¤Ï¥«¡¼¥É¤½¤Î¤â¤Î¤òɽ¤·Ì¾Á°¤¬¡Øcard¡Ù¤Ç¤¹¡£»Ä¤ê¤Î£²¤Ä¤Ï¸¶²è¤ÎÌò³ä¤ò²Ì¤¿¤·¤Þ¤¹¡£Ì¾Á°¤Ï¡Øback¡Ù¤È¡Øfront¡Ù¤È¤·¤Æ¤ª¤­¤Þ¤¹¡£

350.gif

¥«¡¼¥É¤ÎɽÌ̤È΢Ì̤ÎξÊý¤ËÁêÅö¤¹¤ë²èÁü¤ò¥í¡¼¥É¤·¤Æ¤ª¤­¡¢Å¬µ¹Ì¾Á°¤òÊѹ¹¤·¤Þ¤¹¡£
¥«¡¼¥É¤½¤Î¤â¤Î¤òɽ¤¹card¤ÏPictureSizeMode¥×¥í¥Ñ¥Æ¥£¤òÊѹ¹¤·¤ÆfmPictureSizeModeStretch¤ËÀßÄꤷ¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£
¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤òÄɲ䷤ơ¢¤³¤ì¤Ç¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¤Î½àÈ÷¤Ï´°Î»¤Ç¤¹¡£

¤¢¤È¤Ç¥³¡¼¥É¤¬µ­½Ò¤·¤ä¤¹¤¤¤è¤¦¤Ë¡¢³Æ¥³¥ó¥È¥í¡¼¥ë¤Î̾Á°¤òÊѹ¹¤·¤Æ¤ª¤¯¤Î¤ò˺¤ì¤º¤Ë¤ä¤Ã¤Æ¤ª¤­¤Þ¤·¤ç¤¦¤Í¡£


¢£¹Í¤¨Êý¤È¥³¡¼¥É¤Îµ­½Ò

¥«¡¼¥É¤¬¤á¤¯¤ì¤ë¤è¤¦¤Ê±é½Ð¤ò¹Ô¤¦¤¿¤á¤Ë¤Ï¡¢¤É¤Î¤è¤¦¤Ë¥³¡¼¥É¤òµ­½Ò¤¹¤ì¤Ð¤¤¤¤¤Î¤Ç¤·¤ç¤¦¤«¡£¿Í´Ö¤Î»ëÅÀ¤ËΩ¤Ã¤Æ¹Í¤¨¤Æ¤ß¤Þ¤·¤ç¤¦¡£

¥«¡¼¥É¤¬»ëÀþ¤ËÂФ·¤ÆÄ¾³Ñ¤Ë¸ºß¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢¼¡¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¤Í¡£

351.gif

¥«¡¼¥É¤¬»ëÅÀ¤ËÂФ·¤ÆÄ¾³Ñ¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤Î¤Ç¡¢¥«¡¼¥É¤¬¤½¤Î¤Þ¤Þ¸«¤¨¤ë¤À¤±¤Ç¤¹¡£
¤½¤·¤Æ¡¢¥«¡¼¥É¤¬¤á¤¯¤ì¤Æ¤¤¤¯ÅÓÃæ¤ÎÃʳ¬¤Ç¤Ï¡¢¤³¤ó¤ÊÉ÷¤Ë¤Ê¤ê¤Þ¤¹¤Í¡£

352.gif

»ëÅÀ¤«¤é¸«¤¿¥«¡¼¥É¤ÎÉý¤Ï¡¢¤á¤¯¤ì¤Æ¤¤¤¯Ãæ¤Ç¤À¤ó¤À¤ó¶¹¤¯¤Ê¤Ã¤Æ¤¤¤­¤Þ¤¹¡£
´°Á´¤Ë»ëÀþ¤È¿åÊ¿¤Ë¤Ê¤Ã¤¿¤È¤­¡¢¥«¡¼¥É¤Ï¤Û¤È¤ó¤É¸«¤¨¤Ê¤¯¤Ê¤ê¡¢º£Å٤ϤÀ¤ó¤À¤óÉý¤¬¹­¤¬¤Ã¤Æ¤¤¤­¤Þ¤¹¡£
´°Á´¤Ë¤á¤¯¤ê½ª¤ï¤ë¤È¡¢¥«¡¼¥É¤ÏºÆ¤Ó»ëÀþ¤ËÂФ·¤ÆÄ¾³Ñ¤ËÌá¤ê¤Þ¤¹¡£

¤³¤³¤Ç½ÅÍפʤΤϡ¢¤á¤¯¤ì¤Æ¤¤¤¯Ãæ¤Ç¡¢¤Ï¤¸¤á¤Ï¡Ø Éý¤¬¶¹¤¯¤Ê¤Ã¤Æ¤¤¤­ ¡Ù΢ÊÖ¤ë¤È¡Ø Éý¤¬¹­¤¯¤Ê¤Ã¤Æ¤¤¤¯ ¡Ù¤È¤¤¤¦¤³¤È¤Ç¤¹¡£
¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ÎÉý¤¬¡¢¶¹¤¯¤Ê¤ë¢Í¹­¤¯¤Ê¤ë¡¢¤È¤¤¤¦¶ñ¹ç¤ËϢ³¤·¤Æ½èÍý¤Ç¤­¤ì¤Ð¡¢¥«¡¼¥É¤Î¤á¤¯¤ì¤ëưºî¤ò¼Â¸½¤Ç¤­¤ë¤Î¤Ç¤¹¡£

¤½¤ì¤Ç¤Ï¼ÂºÝ¤Ë¥³¡¼¥É¤ò¸«¤Æ¤ß¤Þ¤¹¡£

'APIÀë¸À¤ÈÊÑ¿ôµÚ¤ÓÄê¿ô¤ÎÀë¸À
Public Declare Function GetTickCount Lib "kernel32" () As Long
Public Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMillsecounds As Long)

Public Stime As Long
Public Fronts As Boolean

Public Const Card_Left As Single = 72
Public Const Card_Width As Single = 90


Sub Turn()

    Dim Before As Boolean
    Dim Flg As Boolean
    
    Before = True
    
    With UserForm1.card
        Do Until Flg
            Stime = GetTickCount
            If Before Then
                .Width = .Width - 4
                If .Width < 5 Then
                    Before = False
                    If Fronts Then
                        .Picture = UserForm1.back.Picture
                        Fronts = False
                    Else
                        .Picture = UserForm1.front.Picture
                        Fronts = True
                    End If
                End If
            Else
                .Width = .Width + 4
                If .Width > Card_Width Then
                    .Width = Card_Width
                    Flg = True
                End If
            End If
            .Left = Card_Left + (Card_Width - .Width) / 2 '­¡
            DoEvents
            Do
                Sleep 1
            Loop Until GetTickCount - Stime > 10
        Loop
    End With
        
End Sub


'ɸ½à¥â¥¸¥å¡¼¥ë¤³¤³¤Þ¤Ç
'¤³¤³¤«¤é¤Ï¥Õ¥©¡¼¥à¥â¥¸¥å¡¼¥ë

Private Sub CommandButton1_Click()

    CommandButton1.Enabled = False
    
    Turn
    
    CommandButton1.Enabled = True

End Sub

Private Sub UserForm_Initialize()

    Me.Height = 215

    With card
        .Top = 18
        .Left = Card_Left
    End With

    Fronts = False

End Sub

¤½¤ì¤Ç¤ÏºÇ½é¤«¤é¸«¤Æ¤¤¤­¤Þ¤¹¡£

¤Þ¤º¤Ï¡¢API¤ÎÀë¸À¤ÈÊÑ¿ôµÚ¤ÓÄê¿ô¤ÎÀë¸À¤Ç¤¹¡£
API¤ÏSleep´Ø¿ô¤ÈGetTickCount´Ø¿ô¤Î£²¼ïÎà¤Ç¤¹¡£¤³¤ì¤Ï¥ë¡¼¥×½èÍýÃæ¤ÎƱ´ü¤ò¼è¤ë¤¿¤á¤Ë»È¤¤¤Þ¤¹¡£º£¤Þ¤Ç¤Î¥²¡¼¥àºîÀ®¤Ê¤É¤Ç¤â»È¤Ã¤Æ¤­¤¿API¤Ê¤Î¤Ç¡¢¤³¤³¤Ç¤Ï¾Ü¤·¤¤ÀâÌÀ¤Ï¤·¤Þ¤»¤ó¡£

¼¡¤ËÊÑ¿ô¤Ç¤¹¤¬¡¢¤³¤ì¤â£²¤Ä¡¢Public¤ò»È¤Ã¤ÆÀë¸À¤·¤Æ¤¤¤Þ¤¹¡£
Stime¤ÏƱ´ü½èÍý¤Î¤¿¤á¤Ë»È¤¤¤Þ¤¹¡£°ìÊý¡¢Fronts¤Ï¥«¡¼¥É¤¬º£¸½ºßɽ¸þ¤­¤Ê¤Î¤«¡¢¤½¤ì¤È¤â΢¸þ¤­¤Ê¤Î¤«¡¢¤½¤ì¤ò´ÉÍý¤¹¤ë¤¿¤á¤Ë»È¤¤¤Þ¤¹¡£

Äê¿ô¤â£²¤Ä¤Ç¤¹¡£¤³¤Á¤é¤Ïɬ¤º¤·¤âÄêµÁ¤·¤Ê¤¯¤Æ¤â¤¤¤¤¤Î¤Ç¤¹¤¬¡¢¸å¤«¤é¥³¡¼¥É¤ò½¤Àµ¤¹¤ë¤È¤­¤Î¼ê´Ö¤ò¹Í¤¨¤ÆÀë¸À¤·¤Æ¤¤¤Þ¤¹¡£¥«¡¼¥É¤Î²£°ÌÃÖ(Left)¤ÈÉý(Width)¤Îµ¬ÄêÃͤòÀßÄꤷ¤Æ¤¤¤Þ¤¹¡£

¤½¤Î²¼¡¢Turn¤È¤¤¤¦Ì¾Á°¤Î¥×¥í¥·¡¼¥¸¥ã¤¬¡¢¼ÂºÝ¤Ë¥«¡¼¥É¤Î¤á¤¯¤ì¤ëưºî¤ò½èÍý¤¹¤ë¥×¥í¥·¡¼¥¸¥ã¤Ç¤¹¡£
¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤¬¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Î¥³¥Þ¥ó¥É¥Ü¥¿¥ó¤«¤é¸Æ¤Ó½Ð¤µ¤ì¤ë¤È¡¢¥æ¡¼¥¶¡¼¥Õ¥©¡¼¥à¾å¤Î¥«¡¼¥É¤¬Î¢ÊÖ¤ê¤Þ¤¹¡£

¤½¤·¤Æ¡¢¤³¤Î¥×¥í¥·¡¼¥¸¥ã¤ÎÃæ¤Ç¤âÊÑ¿ô¤òÀë¸À¤·¤Æ¤¤¤Þ¤¹¤Í¡£¤³¤Á¤é¤â£²¤ÄÀë¸À¤µ¤ì¤Æ¤¤¤Þ¤¹¡£Before¤È¤¤¤¦ÊÑ¿ô¤Ï¡¢º£¸½ºß¤Î¾õÂÖ¤¬¡¢¤á¤¯¤êºî¶È¤ÎÁ°È¾¤«¸åȾ¤«¤ò´ÉÍý¤·¤Þ¤¹¡£¤·¤«¤·¤Ê¤¼¡¢Á°È¾¤È¸åȾ¤òʬ¤±¤Æ½èÍý¤·¤Ê¤±¤ì¤Ð¤¤¤±¤Ê¤¤¤Î¤Ç¤·¤ç¤¦¡£
Àè¤Û¤É¤â½ñ¤¤¤¿¤è¤¦¤Ë¡¢¥«¡¼¥É¤¬¤á¤¯¤ì¤Æ¤¤¤¯²áÄø¤Ç¤Ï¡¢»Ï¤á¤Ï¥«¡¼¥É¤ÎÉý¤¬¶¹¤¯¤Ê¤Ã¤Æ¤¤¤­¤Þ¤¹¡£¤·¤«¤·¸åȾ¤Ï¥«¡¼¥É¤ÎÉý¤¬¹­¤¬¤Ã¤Æ¤¤¤¯¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£º£¸½ºß¥«¡¼¥É¤ÎÉý¤ò¶¹¤á¤ë¤Ù¤­¤Ê¤Î¤«¡¢¤â¤·¤¯¤Ï¹­¤²¤ë¤Ù¤­¤Ê¤Î¤«¡¢¤³¤ì¤òÊÑ¿ôBefore¤ÇȽÃǤ·¤Æ½èÍý¤¹¤ë¤ï¤±¤Ç¤¹¡£

¤â¤¦¤Ò¤È¤Ä¤ÎÊÑ¿ôFlg¤Ï¡¢¥ë¡¼¥×½èÍý¤«¤éÈ´¤±¤ë¤¿¤á¤Î¥Õ¥é¥°¤ÎÌò³ä¤òô¤¤¤Þ¤¹¡£


¤µ¤Æ¡¢¼ÂºÝ¤Î½èÍý¤ÎÃæ¿È¤Ç¤¹¡£
ÊÑ¿ôBefore¤¬¡¢º£¥«¡¼¥É¤¬¤É¤Î¤è¤¦¤Ê¾õÂÖ¤«¤ò´ÉÍý¤¹¤ë¤Î¤Ç¤·¤¿¤Í¡£¤Þ¤º¤Ï¥×¥í¥·¡¼¥¸¥ã¤Î³«»Ï¤ÈƱ»þ¤Ë¡¢¤³¤ÎÊÑ¿ô¤ËTrue¤òÂåÆþ¤·¤Æ¤ª¤­¤Þ¤¹¡£ÊÑ¿ôBefore¤¬True¤Î¤È¤­¤Ë¤Ï¡¢¤á¤¯¤êưºî¤ÎÁ°È¾¤À¤È¤¤¤¦¤ï¤±¤Ç¤¹¡£

¤â¤·¡¢¤á¤¯¤êưºî¤ÎÁ°È¾¤Ê¤é¤Ð¡¢¥«¡¼¥É¤òɽ¤¹¥¤¥á¡¼¥¸¥³¥ó¥È¥í¡¼¥ë¤ÎÉý¡¢¤Ä¤Þ¤êWidth¤ò¥Þ¥¤¥Ê¥¹¤·¤Æ¶¹¤¯¤·¤Æ¤¤¤­¤Þ¤¹¡£°ìÄê¤ÎÉý¤Þ¤Ç¶¹¤Þ¤Ã¤¿¤é¡¢º£ÅÙ¤ÏÊÑ¿ôBefore¤ËFalse¤òÀßÄꤷ¤Æ¡¢¥«¡¼¥É¤¬¤á¤¯¤ì¤¿¤¢¤È¤Îưºî¤Ë°Ü¤ê¤Þ¤¹¡£¤³¤Î¤È¤­¤Ë¥«¡¼¥É¤Î²èÁü¤òƱ»þ¤ËÀÚ¤êÂØ¤¨¤Æ¤¤¤ë¤Î¤¬¥Ý¥¤¥ó¥È¤Ç¤¹¡£
¥«¡¼¥É¤¬¤á¤¯¤ì¤¿¤¢¤È¤Ï¡¢µÕ¤ËÉý¤ò¹­¤²¤Æ¤¤¤­¤Þ¤¹¡£¤³¤³¤Ç¤â¡¢°ìÄê¤ÎÉý¤Þ¤Ç¹­¤¬¤Ã¤¿¤é¡¢¥ë¡¼¥×½èÍý¤òÈ´¤±¤ë¤è¤¦¤Ë¤·¤Æ¤ª¤­¤Þ¤¹¡£

º£²ó¤Ï­¡¤Ç¼¨¤¹Éôʬ¤¬ºÇ¤âÆñ²ò¤ÊÉôʬ¤Ë¤Ê¤ë¤È»×¤¤¤Þ¤¹¡£
¤³¤³¤Ç¤Ï¡¢¥«¡¼¥É¤Î²£°ÌÃÖ(Left)¤òÀßÄꤷ¤Æ¤¤¤Þ¤¹¡£Äê¿ô¤ò¤¦¤Þ¤¯ÍøÍѤ¹¤ë¤³¤È¤Ç¡¢¤Ç¤­¤ë¸Â¤ê´Êñ¤Ë½èÍý¤Ç¤­¤ë¤è¤¦¤Ë¤·¤Æ¤¤¤Þ¤¹¡£

ËÜÍè¤Î¥«¡¼¥É¤Î²£°ÌÃÖ¤¬Card_Left¤Ç¤¹¡£»ß¤Þ¤Ã¤Æ¤¤¤ë¤È¤­¤Î¥«¡¼¥É¤Î²£°ÌÃ֤Ǥ¹¤Í¡£¤½¤·¤ÆCard_Width¤¬ËÜÍè¤Î¥«¡¼¥É¤ÎÉý¤Ç¤¹¡£
¤á¤¯¤êưºîÃæ¤Ë¤Ï¡¢¥«¡¼¥É¤ÎÉý¤¬¾ï¤ËÊѹ¹¤µ¤ì³¤±¤Þ¤¹¤è¤Í¡£¤³¤ì¤ò¤¿¤Àñ¤ËÉý¤ÎÊѹ¹¤À¤±¤Ë¤·¤Æ¤·¤Þ¤¦¤È¡¢²£°ÌÃÖ¤¬Êѹ¹¤µ¤ì¤Ê¤¤¤Î¤Çº¸¤Ë´ó¤Ã¤Æ¤¤¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£

353.gif

    ¢§

354.gif

    ¢§

355.gif

¤É¤¦¤Ç¤¹¤«¡©¡¡¤¿¤À²£Éý(Width)¤òÊѹ¹¤¹¤ë¤À¤±¤Ç¤Ï¡¢Éý¤¬¶¹¤¯¤Ê¤Ã¤Æ¤¤¤¯¤À¤±¤Ê¤Î¤Çº¸¤Ë´ó¤Ã¤Æ¤¤¤Ã¤Æ¤·¤Þ¤¦¤Î¤Ç¤¹¡£

¥«¡¼¥É¤¬Ãæ¿´¤ò¼´¤Ë¤·¤Æ²óž¤·¤Æ¤¤¤ë¤è¤¦¤Ë¸«¤»¤ë¤¿¤á¤Ë¤Ï¡¢¾ï¤Ë¥«¡¼¥É¤ÎÃæ¿´¤òµá¤á¤Æ²£°ÌÃÖ¤ò½¤Àµ¤·¤Ê¤±¤ì¤Ð¤¤¤±¤Þ¤»¤ó¡£­¡¤ÎÉôʬ¤Î¥³¡¼¥É¤Ç¤Ï¡¢¤½¤ì¤ò¤ä¤Ã¤Æ¤¤¤ë¤Î¤Ç¤¹¡£

.Left = Card_Left + (Card_Width - .Width) / 2

ËÜÍè¤ÎÉý¤«¤é¡¢¸½ºß¤ÎÉý¤ò°ú¤±¤Ð¡¢º£¤É¤ì¤¯¤é¤¤Éý¤¬¶¹¤Þ¤Ã¤¿¤«¤¬¤ï¤«¤ê¤Þ¤¹¡£¤â¤·Éý¤¬10¥Ý¥¤¥ó¥È¶¹¤Þ¤Ã¤Æ¤¤¤¿¤Ê¤é¡¢Ãæ¿´¤ò¼´¤Ë¹Í¤¨¤ë¤Î¤Ç¡¢È¾Ê¬¤Î5¥Ý¥¤¥ó¥È°Üư¤µ¤»¤ì¤Ð¤¤¤¤¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£¾¯¤·¤ï¤«¤ê¤Ë¤¯¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡¢¤è¡¼¤¯¼°¤ò¸«¤Æ¹Í¤¨¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¤Í¡£


¢£¤Þ¤È¤á

¥«¡¼¥É¥²¡¼¥à¤Ï¡¢·ã¤·¤¯Æ°¤¯¥¢¥¯¥·¥ç¥ó¥²¡¼¥à¤Ê¤É¤ÈÈæ¤Ù¤ë¤È¡¢¤É¤¦¤·¤Æ¤âÃÏÌ£¤Ê°õ¾Ý¤Ë¤Ê¤ê¤¬¤Á¤Ç¤¹¡£¥«¡¼¥É¤¬¤á¤¯¤ì¤ë¤È¤¤¤¦Ã±½ã¤Ê±é½Ð¤Ç¤â¡¢¤½¤Î¸ú²Ì¤ÏÈó¾ï¤ËÂ礭¤¤¤â¤Î¤È¤Ê¤ê¤Þ¤¹¡£

º£²ó¤Î½èÍý¤ÇÃí°Õ¤·¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¤Î¤Ï¡¢¥³¥ó¥È¥í¡¼¥ë¤ÎWidth¥×¥í¥Ñ¥Æ¥£¤òÀßÄꤹ¤ë¤È¤­¤Ç¤¹¡£
¥³¥ó¥È¥í¡¼¥ë¤ÎÉý¤òɽ¤¹Width¥×¥í¥Ñ¥Æ¥£¤ä¡¢¹â¤µ¤òɽ¤¹Height¥×¥í¥Ñ¥Æ¥£¤Ê¤É¡¢Éý¤òÄêµÁ¤¹¤ë¥×¥í¥Ñ¥Æ¥£¤Ë¤Ï¥Þ¥¤¥Ê¥¹¤Î¿ôÃͤòÀßÄê¤Ç¤­¤Ê¤¤¤Î¤ÇÃí°Õ¤·¤Æ¤¯¤À¤µ¤¤¡£
¤â¤·¥Þ¥¤¥Ê¥¹¤Î¿ôÃͤòÀßÄꤷ¤è¤¦¤È¤¹¤ë¤È¡¢¥¨¥é¡¼¤¬µ¯¤­¤Æ½èÍý¤¬»ß¤Þ¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£¤³¤ì¤Ï¤É¤ó¤Ê¥³¥ó¥È¥í¡¼¥ë¤Ç¤¢¤Ã¤Æ¤â¶¦Ä̤¹¤ë»ÅÍͤǤ¹¡£Éý¤òɽ¤¹¥×¥í¥Ñ¥Æ¥£¤Ë¤Ï¥Þ¥¤¥Ê¥¹¤Î¿ôÃͤòÀßÄê¤Ç¤­¤Ê¤¤¤È³Ð¤¨¤Æ¤ª¤­¤Þ¤·¤ç¤¦¡£

¥«¡¼¥É¤ò¤á¤¯¤ë½èÍý¼«ÂΤϡ¢Ãæ¿´¤ò¼´¤Ë¤·¤Æ²£°ÌÃÖ¤òÄ´À°¤¹¤ë¡¢¤È¤¤¤¦¤È¤³¤í¤µ¤¨Íý²ò¤Ç¤­¤ì¤Ð¡¢¤½¤ì¤Û¤ÉÆñ¤·¤¤¤â¤Î¤Ç¤Ï¤Ê¤¤¤È»×¤¤¤Þ¤¹¡£¥µ¥ó¥×¥ë¤òºîÀ®¤·¤Æ¤ª¤­¤Þ¤·¤¿¤Î¤Ç¤½¤Á¤é¤â»²¹Í¤Ë¡£


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



¢£³Ê¸À

¥×¥í¥Ñ¥Æ¥£¤òÍ­¸ú¤ËÍøÍѤ¹¤ë
¥«¡¼¥É¤á¤¯¤ê¤Ç¤ÏÃæ¿´¤ò¹Í¤¨¤Æ²£°ÌÃÖ¤òÄ´À°


PictureSizeMode¤ò¥­¥Á¥ó¤ÈÀßÄꤷ¤Æ¤ª¤«¤Ê¤¤¤È¤¦¤Þ¤¯¤¤¤­¤Þ¤»¤ó¡£






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