ªð¦^¦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 : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD