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

[µo°Ý] ¸Ó¦p¦óÅý¤£¦PÀx¦s®æªº­ÈÅã¥Ü¦b¦P¤@®æ¸Ì?

[µo°Ý] ¸Ó¦p¦óÅý¤£¦PÀx¦s®æªº­ÈÅã¥Ü¦b¦P¤@®æ¸Ì?


¦pªþ¥ó
¦p¦óÅýA1 B1 C1ªº­ÈÅã¥Ü¦bA5¤¤¡A¨Ã¥O¥L¥H"A1, B1, 100%, C1"¤è¦¡Åã¥Ü¥X¨Ó? ¸Ó¥Î¤°»ò«ü¥O©O?

1.¨ç¼Æ
=A1&","&B1&","&"100%,"&C1
2.VBA
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  [A5] = [A1] & "," & [B1] & "," & "100%," & [C1]
End Sub
ù

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD