Try this:
Public StartTIme
Public EndTime
Public ResTime As String
Sub StartTimer()
MsgBox "Time Start Now"
StartTIme = Time
End Sub
Sub EndTimer()
EndTime = Time
ResTime = Format(StartTIme - EndTime, "hh:mm:ss")
MsgBox "Total " &
Range("rngFilled").SpecialCells(xlCellTypeConstants).Cells.Count & " Filled
In " & Minute(ResTime) & " Minute " & Second(ResTime) & " Second" & " Time",
vbInformation
StartTIme = Empty
EndTime = Empty
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 13 May 2012 1:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
Excel (Only for numeric keys)?
@Ranjan, Unprotech sheet password = 007
On Sun, May 13, 2012 at 1:21 AM, Indrajit $nai <talk2indra...@gmail.com>
wrote:
@Ranjan, I have attached the file, hope you can understand actually what I
am looking for? I have used your code in it but is displaying the count
only, means if I filled 24 cells in 3 minutes still it is showing "Total
cells filled in a minute is 24"!!!!!!!! can you please check it once, and
revert me the same.....
On Fri, May 11, 2012 at 10:53 PM, Indrajit $nai <talk2indra...@gmail.com>
wrote:
Thanks Ranjan.....
On Fri, May 11, 2012 at 8:46 PM, Rajan_Verma <rajanverma1...@gmail.com>
wrote:
Hope it will work for you
Public blnFlag As Boolean
Sub StartTimer()
If blnFlag = True Then
MsgBox "Total Cells Fillled in a minute is =" &
Sheet1.UsedRange.SpecialCells(xlCellTypeConstants).Count
'Sheet1.UsedRange.ClearContents
blnFlag = False
End
Else
MsgBox "Time Start"
blnFlag = True
Application.OnTime Now + TimeValue("00:01:00"), "StartTimer"
End If
End Sub
Regards
Rajan verma
+91 7838100659 <tel:%2B91%207838100659> [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 11 May 2012 4:40
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
Excel (Only for numeric keys)?
Yes, Ranjan.....
On Sun, May 6, 2012 at 7:52 PM, Rajan_Verma <rajanverma1...@gmail.com>
wrote:
You mean, You want to know how many cells you can fill in a minute?
Regards
Rajan verma
+91 7838100659 <tel:%2B91%207838100659> [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 05 May 2012 03:57
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel
(Only for numeric keys)?
Hi All,
Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
Can anyone have Typing Practice kind of Macro in Excel, through that we can
measure our typing speed?
If anyone have this kind of thing then please send me the same.
Thanks in advance.....
--
Indrajit
talk2indra...@gmail.com
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient you are hereby notified
that any disclosure, copying, distribution or taking any action in reliance
on the contents of this information is strictly prohibited and may be
unlawful.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
