Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

2012-03-26 Thread Abdulgani Shaikh
Thanks a log Indrajit, I am searching for such kind of solution, as you are already working on log-out time tracking, please send after completion of your VB code. Regards On Thu, Mar 22, 2012 at 3:51 AM, Indrajit $nai wrote: > Thanks @ Ranjan, but I don't track it in MS-Access File, can you >

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

2012-03-23 Thread dguillett1
Glad to help Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Indrajit $nai Sent: Thursday, March 22, 2012 5:59 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro. Thanks @ dguillett1

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

2012-03-22 Thread Indrajit $nai
n 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, rel

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

2012-03-22 Thread dguillett1
e 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, dguillet

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

2012-03-21 Thread dguillett1
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

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

2012-03-20 Thread dguillett1
Using the sub below,anytime you make an entry in col A you get now in col B. It’s automatic. Goes in the sheet module. See attached. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 _ Or Target.Row < 2 _ Or Target.Column <> 1 Then Exit Sub If Len(Application.Trim(Target))