ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¦p¦ó§ó§ï¬°15¬íÄÁ?

[µo°Ý] ½Ð°Ý¦p¦ó§ó§ï¬°15¬íÄÁ?

½Ð±Ð¦U¦ì«e½ú,¥Ø«e¬°¤@¤ÀÄÁ,½Ð°Ý¦p¦ó§ó§ï¬°15¬í
Sub ¦Û°Ê°O¿ý()
If uMode = 0 Then Exit Sub
If Time > TimeValue(EndTime) Then '¦¬½L®É¶¡¥H«á¤£°õ¦æ
    Sht1.[O8] = "¤w¹L¦¬½L"
    uMode = 0
    Exit Sub
End If
Sht1.Range("B1") = Time '·í«e®É¶¡¡]®É¶¡½Xªí¡^
'----------------------------------------------------------
'¨C¢°¤ÀÄÁ°O¿ý¡A¢´¤ÀÄÁ«h§ï¬° Mod 5
If Second(Time) = 0 And Minute(Time) Mod 1 = 0 Then
   xRow = Sht1.Range("A65536").End(xlUp).Row + 1
   If xRow < 9 Then xRow = 9
   Sht1.Range("A" & xRow & ":N" & xRow).Value = Sht1.Range("A1:N1").Value
   '------------------------------------------------
   If ActiveSheet.Name = Sht1.Name And xRow > 20 Then
      ActiveWindow.ScrollRow = xRow - 18 'Åý³Ì·s¸ê®Æ«O«ù¦b¥i¨£µøµ¡¤¤
   End If
   ThisWorkbook.Save   ' ¦sÀÉ
   Beep
End If
Application.OnTime Now + TimeValue("00:00:01"), "¦Û°Ê°O¿ý"   '¨C¤@¬í»¼°j¤@¦¸
End Sub

If Second(Time) Mod 15 = 0 Then

TOP

¦^´_ 2# ­ã´£³¡ªL
ª©¥D ·PÁÂ~~~´ú¸Õ¦¨¥\¤F

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD