- ©«¤l
- 364
- ¥DÃD
- 39
- ºëµØ
- 0
- ¿n¤À
- 404
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-11
- ³Ì«áµn¿ý
- 2024-4-18
|
¦^´_ 22# c_c_lai
Private Sub Worksheet_Change(ByVal Target As Range)
' ·í D2 Äæ¦ì¦³²§°Ê®É¡A «h¥h©I¥s RecordPrice ªº¤èªk (Method)¡C
If Target.Address = "$C$2" Or Target.Address = "$E$2" Or Target.Address = "$G$2" Or Target.Address = "$I$2" Or _
Target.Address = "$K$2" Or Target.Address = "$M$2" Or Target.Address = "$O$2" Or _
Target.Address = "$Q$2" Or Target.Address = "$S$2" Or Target.Address = "$U$2" Then
Call RecordPrice(Target.Address)
End If
End Sub
C¤j¥H¤Wªº¦a¤è¦pªG§Ú¦³100ÀɪѲ¼¡A¬On¥´100Ó¶Ü??:'( |
|