ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¨CÂIÀ»¸ÓÀx¦s®æ¦Û°Ê±q¸ÓÀx¦s®æ¤¤ªº¥|­Ó¦r¤À¥X¨Ó¨ìG,H,I,J©O?

ÁÙ¦³­Ó«Ü±`¥Îªº¡G
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 3 And Target.Column <> 4 Then Exit Sub
   Target.Parse "[xxxx][xxxx][xxxx][xxxx]", Cells(Target.Row, 7)
End Sub

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD