Thanks @ dguillett1.....
On Thu, Mar 22, 2012 at 6:36 PM, dguillett1 <dguille...@gmail.com> wrote: > 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 <talk2indra...@gmail.com> > *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 <talk2indra...@gmail.com> >> *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 >> > > > > -- > 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
