- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 277
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-23
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-2-11 23:55 ½s¿è
¦^´_ 16# leefing
§Ú¥u¦³yeswin¸Õ¥Îª©
°²³][J12]ªºDDE³sµ²¤½¦¡=YES|DQ!EXFB2.Volume
´£¨Ñ§A´ú¸Õ¬Ý¬Ý
¦bSheet1¼Ò²Õ¼W¥[Worksheet_Calculateµ{§Ç- Private Sub Worksheet_Calculate()
- ThisWorkbook.SetLinkOnData "YES|DQ!EXFB2.Volume", "Catch_DDE"
- End Sub
½Æ»s¥N½X ¦b¤@¯ë¼Ò²Õ- Sub Catch_DDE()
- MsgBox "J1¼ÆÈÅÜ°Ê" '¦¹¦æ´ú¸Õ¬O§_J12ªºDDE§ó·s¡A¥i¨ú®ø
- With Sheet1
- If .[J12].Value >= 10 Then
- If .[D12] = .[F12] Then .[U12] = .[U12] + .[J12]
- If .[E12] = .[F12] Then .[T12] = .[T12] + .[J12]
- End If
- End With
- End Sub
- Sub Auto_Open() '¶}Àɮɦ۰ʰõ¦æ
- With Sheet1
- .[U12:T12] .ClearContents
- End With
- End Sub
½Æ»s¥N½X |
|