I would use a sheet change event:
'----------------------------------------------------------------------------------------

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Targ As Range
    For Each Targ In Target
        If Targ.Column = 1 Then
            Application.EnableEvents = False
            If (Targ.Value & "X" = "X") Then
                Cells(Targ.Row, "B").ClearContents
            Else
                If (Cells(Targ.Row, "B") & "X" = "X") Then Cells(Targ.Row, "B") 
= Now
            End If
            Application.EnableEvents = True
        End If
    Next Targ
End Sub
 
'----------------------------------------------------------------------------------------

 
Paul


>
>From: Ramkesh Maurya <sunscel...@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Wed, September 29, 2010 2:36:06 PM
>Subject: Re: $$Excel-Macros$$
>
>
>Dear Dave,
>
>Thanks for paying attention,
>
>Yes I am allowed to use Macro & I want the date in Col B only when the 
>adjecent 
>cell Col A received some text for the first time
>
>Regards
>Ramkesh
>
>
>On Wed, Sep 29, 2010 at 7:50 AM, Dave Bonallack <davebonall...@hotmail.com> 
>wrote:
>
>A further question: Do you want the date in Col B to enter only when the 
>adjacent cell in Col A receives text for the first time, or any time the 
>adjacent Col A cell is changed? 
>
>>
>>Regards - Dave.
>> 
>>________________________________
Date: Tue, 28 Sep 2010 23:40:09 +0530
>>Subject: $$Excel-Macros$$ 
>>From: sunscel...@gmail.com
>>To: excel-macros@googlegroups.com
>>
>>
>>Dear All, Xl Mania(s)
>>
>>I really appreciate this group for learning 
>>I have lrarnet a lot of tricks from this group which enabled me to come of 
>>with 
>>flying colours.Today i am posting my first query briefing in below 
>>lines-----------
>>
>> 1- I fill some text in column A (say)
>> 2- I want that the date of filling data should appear in column B (beside 
>>the 
>>column A)
>>
>>Now condition is -----
>>
>> 3 -Date in column B should not be updated by re-calculation nature of Excel 
>>or 
>>user
>>
>>
>>I know that anybody will help me so thanks in advance !
>>
>>-- 
>>
>>
>>Ramkesh
>>
>>
>>-- 
>>----------------------------------------------------------------------------------
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>3. Excel tutorials at http://www.excel-macros.blogspot.com/
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>> 
>><><><><><><><><><><><><><><><><><><><><><><>
>>Like our page on facebook , Just follow below link
>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>>-- 
>>----------------------------------------------------------------------------------
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>> 
>><><><><><><><><><><><><><><><><><><><><><><>
>>Like our page on facebook , Just follow below link
>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>-- 
>
>
>Ramkesh
>9990260398
>-- 
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Reply via email to