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

½Ð°Ý ªþ¥óªºµ{¦¡½X¸Ó¦p¦ó§ïµ½?

½Ð°Ý ªþ¥óªºµ{¦¡½X¸Ó¦p¦ó§ïµ½?

½Ð°Ýª©¥D

§Úª½±µ½Æ»s²Ä¤@¬qµ{¦¡½X°µ²Ä¤G¬q  ¥i¬O²Ä¤G¬q«o³£µLªk¹B§@
·Q°Ý¸Ó¦p¦ó§ïµ½?  ·PÁÂ~

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address <> "$D$13" Then Exit Sub
If Target = "­¿¼Æ" Then [D27:D27] = "" Else [D27:D27].FormulaR1C1 = "¬Y¤½¦¡"

'¥H¤U¬O²Ä¤G¬q
If Target.Address <> "$E$13" Then Exit Sub
If Target = "­¿¼Æ" Then [E27:E27] = "" Else [E27:E27].FormulaR1C1 = "¬Y¤½¦¡"
End Sub

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD