Hi
In workbook code module Paste this :
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopIt
End Sub
Private Sub Workbook_Open()
GetStart
End Sub
in Standart Module paste this:
Sub GetStart()
Range(A1).Value = Format(Now, HH:MM:SS)
Application.OnTime Now +
Rajan ..
I created an add ins to add to the clock
its purpose is to determine the timecode breaks
talk about its usefulness
example
Stat End time difference
21:49:23,66 21:49:28,61 00:00:04,95
Chilexcel
2012/6/19 Rajan_Verma
nice
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: 19 June 2012 9:09
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: How to creat digital watch
Thanks a lot rajan jee..!
--
*Suman Kumar*
On Tue, Jun 19, 2012 at 4:21 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hi
In workbook code module Paste this :
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopIt
End Sub
Private Sub Workbook_Open()
GetStart
Rajan
only commented the work I've done
1 .- move the cursor and enter hours
2 .- hours Clickleft button entry
3 .- add ins stopwatch to determine differences
4 .- formulated to test differences
Atte
Chilexcel
2012/6/19 Suman ksuman1...@gmail.com
Thanks a lot rajan jee..!
--