½Ð°Ý°ª¤ân±N¥H¤UDDE ¨C¤ÀÄÁ°O¿ý§ï¬°30¬í¦Û°Ê°O¿ý¤@¦¸n«ç§ï
- ©«¤l
- 18
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 34
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- winxp
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-11
- ³Ì«áµn¿ý
- 2012-10-5
|
½Ð±Ðc_c_lai,¥i¥H¶Çµ¹§Ú¦¹ÀɶÜ? thanks a lot! |
|
|
|
|
|
|
- ©«¤l
- 44
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 78
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- SP3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taipei
- µù¥U®É¶¡
- 2012-5-4
- ³Ì«áµn¿ý
- 2014-4-24
|
¦^´_ 23# c_c_lai
¦¬¨ì,ÁÂÁ±z¼ö¤ßªº¤À¨É,¯¬±z°]·½ºuºu... |
|
stock
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 21# usana642
1. ½Ð±N¤U¦Cµ{¦¡½X½Æ»s¨ì ThisWorkbook ¼Ò²Õ¤º¡A¨Ã¤©Àx¦s¡C- Option Explicit
- Dim timerEnabled As Boolean ' §P©w¶}±Ò¥»¤u§@ªí³æªº®É¬q¬O§_¬°¶}½L«e±Ò°Ê¡C
- Dim Pos As Integer ' ±N¨C¹j "¦h¤Ö®É¶¡" ³B²z®É¬q¡A²¾¨ì¦¹³B¨Ó³B²z¡C
- Private Sub Workbook_Open()
- Pos = Sheets("µ¦²¤°O¿ý").Range("B" & Rows.Count).End(xlUp).Row
- If (Pos < 11) Then Pos = 10
- Sheets("µ¦²¤°O¿ý").Cells(4, 2) = Pos
- If (Sheets("µ¦²¤°O¿ý").Range("B6").Value = "") Then Sheets("µ¦²¤°O¿ý").Range("B6").Value = "08:45:00"
- If (Sheets("µ¦²¤°O¿ý").Range("B7").Value = "") Then Sheets("µ¦²¤°O¿ý").Range("B7").Value = "13:45:00"
- If (Sheets("µ¦²¤°O¿ý").Range("B8").Value = "") Then Sheets("µ¦²¤°O¿ý").Range("B8").Value = "00:00:30"
-
- timerEnabled = False
- Call timerStart ' µ{¦¡¤@±Ò©l¡A«K¥h¦Û°Ê°õ¦æ timerStart
- End Sub
- Private Sub Workbook_BeforeClose(Cancel As Boolean)
- On Error Resume Next
- Application.OnTime Now + TimeValue("00:00:01"), "ThisWorkbook.Timer", , False
-
- Me.Save
- End Sub
- Public Sub Timer()
- On Error Resume Next
- If (TimeValue(Now) > Sheets("µ¦²¤°O¿ý").Range("B7").Value) Then Exit Sub
-
- If (TimeValue(Now) >= Sheets("µ¦²¤°O¿ý").Range("B6").Value) Then ' ¶}½L¡B¦¬½L®É¬q³]©w
- ' ½L¤¤³B²z¡A±N¸ê®Æ¶×¤J¼g¤J¤u§@ªí³æ¤ºÀx¦s¡C
- With Sheets("µ¦²¤°O¿ý")
- .Cells(3, 2) = Time ' ±N®É¶¡ Show ¦Üµ¦²¤ªº B3 Äæ¦ì
- Pos = Pos + 1 ' ±NÅܰʦ渹¥[¤@¦æ
- .Cells(4, 2) = Pos
-
- .Cells(Pos, 1) = Time
- .Cells(Pos, 2).Offset(0).Resize(, 9) = .[B2:J2].Value
- End With
- End If
-
- Call timerStart
- End Sub
- Sub timerStart()
- If timerEnabled Then
- ' ²Ä¤G¦¸(§t)¥H«á§¡¥H³]©w¤§ "¶¡¹j®É¬q" ¨Ó³B²z°õ¦æ§Çªº§@·~¡C
- Application.OnTime (Now + Sheets("µ¦²¤°O¿ý").Range("B8").Value), "ThisWorkbook.Timer"
- Else
- timerEnabled = True
-
- ' ±N²Ä¤@¦¸±Ò°Ê®É¶¡§ó§ï¬°³]©w "¶}½L®É¶¡"«e¡A¦pªG¶}±Ò Excel ®É¡A¤w¸g¹L¤F³]©w "¶}½L®É¶¡"¡A«h¤@¶i¤J¨t²Î§Yª½±µ¥h°õ¦æ¬ö¿ý§@·~¡C
- If (TimeValue(Now) <= Sheets("µ¦²¤°O¿ý").Range("B6").Value) Then
- Application.OnTime (Sheets("µ¦²¤°O¿ý").Range("B6").Value), "ThisWorkbook.Timer"
- Else
- ' ¨t²Îè³s¤W DDE ¦Ü¸ê®Æ¶×¤JExcel¤u§@ªí³æ¡A¶·¦³¤@Ó½w½Ä®É¬q¡A
- ' ³o®É¦pªG°¨¤W¥h§ì¨úDDE¸ê®Æ¡A·|¦³«¬ºA¤£²Åªº¿ù»~°T®§²£¥Í¡A¨Ã¤¤Â_°õ¦æ§Çªº§@·~¡C
- Application.OnTime (Now + TimeValue("00:00:05")), "ThisWorkbook.Timer"
- End If
- End If
- End Sub
½Æ»s¥N½X 2. ¤u§@ªí³æ¤º®e¦p¹Ï¡A½Ð°Ñ¦Ò¥¦»Pµ{¦¡½X¶¡ªºÃö«Y¤Î¹B§@¡C
3. ¥H¤W§¹¦¨«á¡A¥ý±N¥»±M®×Àx¦s¨ÃÂ÷¶}¡C
4. ±µ¤U¨Ó¥ý¥´¶}¨é°Ó³nÅé
(Ä´¦p¡G§A»s§@ªº¤u§@ªí³æ¬O¸òþ¤@®a¨é°Ó³s½uªº¡A¦p EasyWin¡BeLeader¡B©Î¨ä¥L¨é°Ó³s½u³nÅé)¡A
µM«á±Ò°Ê§A»s§@ªº "¦Û°Ê°O¿ý¨C¤ÀÄÁ©e¶R½æ§¡È" Excel¡A¨Ã¦P®É³s¤W¨é°Ó³s½u³nÅé¡A´N¤j¥\§i¦¨¤F¡I
§Æ±æ¥¦¯à§U¯q©ó§A¡A¨Ã¯àÀ°§U§A§ó¤W¤@¼h¼Ó¡C |
|
|
|
|
|
|
- ©«¤l
- 44
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 78
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- SP3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taipei
- µù¥U®É¶¡
- 2012-5-4
- ³Ì«áµn¿ý
- 2014-4-24
|
¦^´_ 20# c_c_lai
c_c_lai ¤j¤j,§Ú¤]»Ýn³oÓÀÉ®×,¦]Åv¤£¨¬µLªk¤U¸ü
¥i§_±H¨ì§Úªº«H½c,·PÁ¼ö¤ß¤À¨É |
|
stock
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2012-6-25 17:34 ½s¿è
¦^´_ 19# mead
§ä¨ì¤F¡A¤w E-Mail ¹L¥h¤F¡I |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2012-6-25 08:42 ½s¿è
¦^´_ 17# mead
ªþ¤W¤@Ó¥i¥HÀH§A»Ý¨D²§°Êªº "¦Û°Ê°O¿ý¨C¤ÀÄÁ©e¶R½æ§¡È"¡A
¥H«á§A´N¨S¦³·Ð´oªº¨Æ¤F¡I
¦Û°Ê°O¿ý¨C¤ÀÄÁ©e¶R½æ§¡È.rar (13.96 KB)
P.S. ½Ð±N Time() ¸Ìªº .Cells(21, 2).Offset(0).Resize(, 9) = .[B12:J12].Value
§ó§ï¦¨ .Cells(Pos, 2).Offset(0).Resize(, 9) = .[B2:J2].Value |
|
|
|
|
|
|
- ©«¤l
- 51
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 59
- ÂI¦W
- 0
- §@·~¨t²Î
- VISTA
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-4-1
- ³Ì«áµn¿ý
- 2018-5-17
|
¥»©«³Ì«á¥Ñ mead ©ó 2012-6-24 10:34 ½s¿è
¸ÕµÛ¦bÅÜ°Ê´T«×³Ì¤pªº«e´£¤Uקï
Option Explicit
Dim LastMin As Long
Private Sub Workbook_Open ...
a8350070 µoªí©ó 2012-5-26 11:03
If Hour(Time) * 3600 + Minute(Time) * 60 + Second(Time) > LastMin + 30 Then '¶}©l«á°µ
³o¼Ë§ï ¨än°O¿ýªº®É¶¡³]©wn´î1
¦p30¬í ´Nn¥[29¦Ó«D30 |
|
|
|
|
|
|
- ©«¤l
- 44
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 78
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- SP3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taipei
- µù¥U®É¶¡
- 2012-5-4
- ³Ì«áµn¿ý
- 2014-4-24
|
ÁÂÁÂa8350070 ©Mc_c_lai ¥Î¤ßªº¸Ñ»¡ |
|
stock
|
|
|
|
|
- ©«¤l
- 44
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 78
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- SP3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taipei
- µù¥U®É¶¡
- 2012-5-4
- ³Ì«áµn¿ý
- 2014-4-24
|
·PÁÂc_c_lai ¤j³o»ò¸Ô²Ó¥Î¤ßªº¸Ñ»¡ |
|
|
|
|
|
|
- ©«¤l
- 4
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 12
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2012-4-4
- ³Ì«áµn¿ý
- 2017-3-6
|
ªì¨Ó¨ì³o¸Ì ¯u¬O°ª¤â¦p¶³
¬Ý¨Ó¥i±o¦n¦n¾Ç²ß¤F |
|
|
|
|
|
|