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

[µo°Ý] ¦U¦ì¤j¤j§Ú¤S¨Ó¤FÁÙ¬OÃö©ó¸õ°ÊDDE­pºâ¦¨¥æ¶q²Î­p°ÝÃD

[µo°Ý] ¦U¦ì¤j¤j§Ú¤S¨Ó¤FÁÙ¬OÃö©ó¸õ°ÊDDE­pºâ¦¨¥æ¶q²Î­p°ÝÃD

Private Sub Worksheet_Calculate()
¦]¬°°£¤F¤§«e¸g¹L¤j¤j«ü¾É«á¾Ç·|ªºÂI¦ì°O¿ý¥~
²{¦bÁٻݭn¦b¬Y­ÓªÅ®æªº¼Æ­È§ïÅÜ«á
§Ú­n¶i¦æ¥[Á`  ¦ý¬O¦³®É­Ô·|¦³³sÄò¨âµ§DDE³£¬O5 5  ÁÙ¬O»Ý­n¥[Á`
³o¼Ë¦³¿ìªk°µ¨ì§P©w¼Æ­È§ïÅܤF¶Ü

§Ú¥u·|¼g¤F¤@¦æ
  If [B4] <> "" Then Range("C" & tr) = Range("B4") + Range("C" & tr)
¦ý¬O³o¼Ëªº¤è¦¡·|Åܦ¨¨C¹j¤@¬q®É¶¡  ´N²Ö¥[B4³o­Ó¼Æ­È  §Ú·Q­n¦³§ïÅܤ~¥[
¤£ª¾¹D­n«ç»ò¼g ÁÙ¬O­n¥Î
worksheet_change???
·PÁ¤j¤j

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD