ªð¦^¦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¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD