Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 _
Or Target.Row < 2 Then Exit Sub
If Target.Column = 1 Or Target.Column = 3 Then
If Len(Application.Trim(Target)) > 0 Then _
Target.Offset(, 1) = Now
End If
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Indrajit $nai
Sent: Thursday, March 22, 2012 1:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time
macro.....
@ dguillett1, PFA for your reference.
On Thu, Mar 22, 2012 at 4:28 AM, dguillett1 <dguille...@gmail.com> wrote:
Without seeing what you want with an example I can’t help
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Indrajit $nai
Sent: Wednesday, March 21, 2012 5:21 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time
macro.....
Thanks @ Ranjan, but I don't track it in MS-Access File, can you incorporate
this codes for MS-Excel?
Thanks @ dguillett1, but I'm not able to use the same code for Logout time
tracking in a different column, can you please help me once again?
@ Abdulgani Shaikh, I have attached the same file in .xls format.
On Wed, Mar 21, 2012 at 11:12 PM, Rajan_Verma <rajanverma1...@gmail.com>
wrote:
It’s a old post on this group ,I have created a small tool to track punch
in and punch out Time , hope it can help.
‘=====================================================================
Hi Lokesh,
I am attaching Two files here..
1). Save Access file at Shared Location.
2). In Code Module Replace Thisworkbook.Path with shared Path
3). Fill AllEmpID table in Database with EMPID for validation.
ObjConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=" & ThisWorkbook.Path & "\table.accdb" & ";"
‘=====================================================================
Regards
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: Mar/Wed/2012 03:17
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need a small help, related to the Date and Time
macro.....
Hi All,
Need a small help from you all. I have attached a file with this mail. Now
if you open the file you can see there is a button named Login, if you click on
it, it will take the system time and date.
There are two columns available, Name (Column A) and Login Time (Column B),
now I want if the respective Column A is blank then it will not put the date
and time in Column B, if there is a name in column A then only date and time
will be captured in the column B, other wise it will give me a error message.
If you have the code for the same then please provide me.
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
--
Indrajit Snai
+91 9051755745
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
