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
>
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
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
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
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
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))