- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 246
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-12
|
¦^´_ 5# mead - Sub Timer()
-
- Dim HHMMSS As Integer
-
- On Error Resume Next
-
- ' Sheets("µ¦²¤°O¿ý").Select
-
- Sheets(2).Cells(2, 1) = Time '±N®É¶¡show¦Üµ¦²¤ªºa2Äæ¦ì
- If (TimeValue(Now) <= TimeValue("08:45:00") Or TimeValue(Now) >= TimeValue("13:45:00")) Then GoTo 10 'Àç·~®É¶¡¤~°õ¦æ
-
- ' If Minute(Time) <> LastMin Then '¶}©l«á°µ
-
- i = i + 1
-
- If i = 60 Then
-
- Sheets(2).Range("a10000").End(xlUp).Offset(1, 0) = Time
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 1) = O
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 2) = H
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 3) = L
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 4) = C
-
-
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 5) = O1
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 6) = H1
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 7) = L1
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 8) = C1
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 9) = O2
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 10) = H2
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 11) = L2
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 12) = C2
-
- i = 0
-
- O = Sheets(2).Cells(2, 2)
-
- H = Sheets(2).Cells(2, 2)
-
- L = Sheets(2).Cells(2, 2)
-
- C = Sheets(2).Cells(2, 2)
-
-
-
- O1 = Sheets(2).Cells(2, 3)
-
- H1 = Sheets(2).Cells(2, 3)
-
- L1 = Sheets(2).Cells(2, 3)
-
- C1 = Sheets(2).Cells(2, 3)
-
-
-
- O2 = Sheets(2).Cells(2, 4)
-
- H2 = Sheets(2).Cells(2, 4)
-
- L2 = Sheets(2).Cells(2, 4)
-
- C2 = Sheets(2).Cells(2, 4)
-
- Else
-
- C = Sheets(2).Cells(2, 2)
-
- If H = "" Then H = Sheets(2).Cells(2, 2)
-
- If C >= H Then H = C
-
- If C < L Then L = C
-
- If O = 0 Then O = Sheets(2).Cells(2, 2) Else O = O
-
- If L = 0 Then L = Sheets(2).Cells(2, 2) Else L = L
-
-
-
- C1 = Sheets(2).Cells(2, 3)
-
- If H1 = "" Then H1 = Sheets(2).Cells(2, 3)
-
- If C1 >= H1 Then H1 = C1
-
- If C1 < L1 Then L1 = C1
-
- If O1 = 0 Then O1 = Sheets(2).Cells(2, 3) Else O1 = O1
-
- If L1 = 0 Then L1 = Sheets(2).Cells(2, 3) Else L1 = L1
-
-
-
- C2 = Sheets(2).Cells(2, 4)
-
- If H2 = "" Then H2 = Sheets(2).Cells(2, 4)
-
- If C2 >= H2 Then H2 = C2
-
- If C2 < L2 Then L2 = C2
-
- If O2 = 0 Then O2 = Sheets(2).Cells(2, 4) Else O1 = O1
-
- If L2 = 0 Then L2 = Sheets(2).Cells(2, 4) Else L2 = L2
-
- End If
-
- LastMin = Minute(Time)
-
- ' End If
- 10
- Application.OnTime Now + TimeValue("00:00:01"), "Timer" '¨C¬íÅã¥Ü
-
- End Sub
½Æ»s¥N½X |
|