- ©«¤l
- 746
- ¥DÃD
- 243
- ºëµØ
- 0
- ¿n¤À
- 1002
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-5-30
- ³Ì«áµn¿ý
- 2024-5-5
|
¥»©«³Ì«á¥Ñ t8899 ©ó 2013-8-7 19:25 ½s¿è
luhpro µoªí©ó 2013-8-6 23:25
¤U± ¨â²Õ±ø¥ó¦P®É¹F¨ì±ø¥ó
¤£ª¾¬°¦ó²Ä¤G²Õªº¹ï¸Ü²°¤£·|¦Û°ÊÃö³¬
¦pªG§â²Ä¤G²Õ»P²Ä¤@²Õ¥ý«á¤¬´«¡A¤S´«²Ä¤@²Õ¤£·|¦Û°ÊÃö³¬
Private Sub Worksheet_Calculate()
Dim sStr$
Dim ZZ As Range
sStr = ""
sStr2 = ""
For Each ZZ In Range("c2:c111")
If Not IsError(ZZ) Then
If ZZ > ZZ.Offset(, 26) * Range("S26").Value And Range("Q26").Value = 1 And flag = True Then
If sStr <> "" Then sStr = sStr & Chr(10)
sStr = sStr & "º¦º¦º¦--»P¤W¤@½L===> " & Cells(ZZ.Row, 2).Value & "=====> " & Round((ZZ - ZZ.Offset(, 26)) / ZZ.Offset(, 26).Value, 4) * 100
End If
If ZZ < ZZ.Offset(, 26) * Range("R26").Value And Range("Q26").Value = 1 And flag = True Then
If sStr2 <> "" Then sStr2 = sStr2 & Chr(10)
sStr2 = sStr2 & "¶^¶^¶^--»P¤W¤@½L===> " & Cells(ZZ.Row, 2).Value & "=====> " & Round((ZZ - ZZ.Offset(, 26)) / ZZ.Offset(, 26).Value, 4) * 100
End If
End If
Next
'²Ä¤@²Õ
If sStr2 <> "" Then
CreateObject("Wscript.shell").Popup sStr2, 2, "Auto Closed MsgBox", 64
Range("Q26").Value = 2
Application.OnTime Now + TimeValue("00:00:15"), "fff"
End If
'²Ä¤G²Õ
If sStr <> "" Then
CreateObject("Wscript.shell").Popup sStr, 2, "Auto Closed MsgBox", 64
Range("Q26").Value = 2
Application.OnTime Now + TimeValue("00:00:15"), "fff"
End If
End Sub |
|