½Ð°Ý ªþ¥óªºµ{¦¡½X¸Ó¦p¦ó§ïµ½?
- ©«¤l
- 82
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 115
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-4-18
|
½Ð°Ý ªþ¥óªºµ{¦¡½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 |
|
|
|
|
|
|