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

[µo°Ý] ¦Û°Ê²M°£¤U©Ô¿ï³æªº¸ê®Æ

[µo°Ý] ¦Û°Ê²M°£¤U©Ô¿ï³æªº¸ê®Æ

½Ð°Ý¤@¤U
§Ú¦³¨â­Ó¤U©Ô¦¡¿ï³æ
¥¨¶°¦³¿ìªk¡A§Ú©Ô²Ä¤@­Ó¤U©Ô¦¡¿ï³æ®É¡A²Ä¤G­Ó·|¦Û°Ê²M°£¤§«e©Ô¹Lªº¸ê®Æ¶Ü¡H
·í§Ú©ÔD7®É,D8·|¦Û°Ê²M°£

Book9.zip (1.6 KB)

¦^´_ 1# imzues
¦¹¨Æ¥óµ{§Ç¬° , ©Ò¦b¤u§@ªíªºµ{¦¡½X. ³o¤u§@ªíÀx¦s®æ¦³­×§ï®É ©Ò¤Þµoªº
Target ¬OÀx¦s®æ¦³­×§ï®É©Ò¶Ç¦^½d³òªºÅܼÆ
  1. Option Explicit
  2. Private Sub Worksheet_Change(ByVal Target As Range)
  3.     If Target.Address = "$D$7" Then [d8] = ""
  4. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD